Arul's.TEG Blog

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT   v_group_user.user_id, v_user.ldap_id,             LTRIM (RTRIM (UPPER (v_user.ldap_id))), v_group.cmid,             v_group.name_en name_en, v_group.name_fr name_fr, v_group.created,             v_group.modified, v_group.disabled, v_user.last_name,             v_user.first_name, v_user.email        FROM dba_group_info v_group,             (SELECT cmid GROUP_ID, refcmid user_id                FROM ops$cgs.cmreford1) v_group_user,             (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,                     c1.surname last_name, c1.givenname first_name,                     c1.email email                FROM cmobjprops1 c1, cmobjprops33 c33               WHERE c33.cmid = c1.cmid(+)              UNION              SELECT cmid user_id, UPPER (name_en) ldap_id, name_en last_name,                     '' first_name, '' email                FROM dba_group_info) v_us

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),           cmobjects.created, cmobjects.modified, cmobjects.disabled,           cmobjnames_base.isdefault      FROM cmobjects, cmobjnames_base     WHERE cmobjects.classid IN (26, 54)       AND cmobjnames_base.mapdlocaleid = 24       AND cmobjects.cmid = cmobjnames_base.cmid

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT cmobjprops1.cmid, cmobjprops1.busphone, cmobjprops1.email,           cmobjprops1.faxphone, cmobjprops1.givenname, cmobjprops1.homephone,           cmobjprops1.mobilephone, cmobjprops1.pagerphone,           cmobjprops1.paddress, cmobjprops1.surname, cmobjprops1.TIMEZONE,           cmobjprops1.clocaleid, cmobjprops1.prodlocale, cmobjprops1.objid,           cmobjprops1.useaccessibility, cmobjprops33.cmid AS cmid1,           UPPER (cmobjprops33.NAME)      FROM cmobjprops1, cmobjprops33     WHERE cmobjprops1.cmid = cmobjprops33.cmid

Open Cognos FM Go to Projects > Options Go to Auto Save Tab and Click Auto Save On and enter the time-frame .   Click OK save the setting.

Chart Types in Cognos 8.4 1. Microcharts 2. Pie Charts 3. Column Charts 4. Marimekko Charts 5. Progressive Column Charts 6. Pareto Charts 7. Win-loss Charts 8. Bar Charts 9. Line Charts 10. Area Charts 11. Combination Charts 12. Radar Charts 13. Scatter Charts 14. Bubble Charts 15. Point Charts 16. Quadrant Charts 17. Polar Charts 18. Metrics Range Charts 19. Gauge Charts 20. Standard Charts 21. Stacked Charts 22. 100 Percent Stacked Charts 23. Three-dimensional Charts