Arul's.TEG Blog

Wondering how many MB your Cognos JVM (Java Virtual Machine) uses? add '?b_action=/diagnostics' to your c8 URL E.g. http://localhost/cognos8/cgi-bin/cognosisapi.dll?b_action=/diagnostics Provide login credentials if required and the result appears. Diagnostics Dispatcher host="localhost" port="9300" capacity="1.0" Memory Amount_of_free_memory_in_the_system="16199.064 KB" Total_memory_in_the_JVM="130955.776 KB" CM host="localhost" port="9300" Diagnostics

Resolving the problem When you run a report, the query request is sent to the database and the result set is returned. After the initial report execution, you may decide to make changes to the report. Often, the report can be created without querying the database again. To take advantage of this, you should turn the query reuse feature on. When query reuse is turned on and you run a report for the first time, the query is stored in the cache of your current session and reused the next time you run the report. The queries are kept in the cache for each user. The cache is cleared when the report consumer exits the reporting tool and returns to the portal or when the report server times out the session, typically after five minutes of inactivity. The first time the report is run and the cache is created, the response time may be slightly negatively impacted. The performance improvement is realized by the report consumer on each subsequent report execution, when the response time is i...

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,          ...

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