Arul's.TEG Blog

How to configure the Cognos 8 gateway in IIS 7.0 Environment Windows Server 2008 Resolving the problem In IIS Manager, create the Cognos 8 virtual directories, enable the gateway under ISAPI and CGI Restrictions, and add a Handler Mapping for the gateway. Edit the IIS configuration file and add the attribute allowPathInfo='true'. Steps: 1. In the left Connections pane, expand the server node, expand Sites, right-click on Default Website, and click Add Virtual Directory. 2. Enter 'cognos8' for the Alias and enter the path to the c8/webcontent directory in Physical Path (default C:\Program Files\cognos\c8\webcontent). Click OK. 3. Right click on the newly-created cognos8 Virtual Directory and click Add Virtual Directory 4. Enter 'cgi-bin' for the Alias and enter the path to the c8/cgi-bin directory in Physical Path (default C:\Program Files\cognos\c8\cgi-bin). Click OK. 5. Right click on the cognos8 Virtual Directory again and click Add Virtual...

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.