Cognos Compatibility

This link gives all the details on different versions of Cognos and it's compatible softwares.

https://www-304.ibm.com/support/docview.wss?uid=swg27014432

Comments

Post a Comment

Popular posts from this blog

Query Cognos 8/10 Content Store

I came across these queries that can give you good insight on the data and maintenance of Content Store in Cognos 8/10. You can also leverage the CMTools utility that comes with cognos install. ..\Cognos\bin\utilities\cm\CMTools\CMTools.exe select count(*) as "total number of objects" from CMOBJECTS; select c.NAME as "class name", count(*) as "number of objects" from CMOBJECTS o, CMCLASSES cgroup by o.CLASSID, c.CLASSID, C.NAME having c.CLASSID=o.CLASSID order by c.NAME ; select c.NAME as "class name", count(*) as "number of secured objects" from CMOBJECTS o, CMCLASSES c, CMPOLICIES pwhere o.CMID=p.CMID and p.POLICIES is not null group by o.CLASSID, c.CLASSID, C.NAME having c.CLASSID=o.CLASSID order by c.NAME ; select count(*) as "Total number of outputs", SUM(cast(coalesce(DATALENGTH(DATAPROP),0) as bigint)) as "Total size of outputs" from CMDATA where DATAPROP is not NULL; select ...
Read more

Cognos 8/10 CAMID-User ID/LDAP ID report

I came across this slick KB article on how to get the list of active sessions/users currently on any cognos environment and implemented it. https://www-304.ibm.com/support/docview.wss?uid=swg21385278 After I got this to work the servlet that runs only retrieves the CAMID and the session start time. I started looking around in the content store tables and was able to successfully  retrieve the CAMID and the associated  LDAP ID/User ID. I made this a query subject in the Audit model and joined it to the security groups table and created a report that will give me User ID, CAMID, AD Group, Name , Email. Query : SELECT  distinct ldap_id,     last_name,     first_name,     email,     objid as CAMID     FROM            (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,                   c1.surname last_name, c1.givenname first_...
Read more

Cognos Audit report that shows reports that are currently running from Report,Query,Powerplay studios

As you might have noticed that on the Cognos audit package the report run details are saved on different tables depending on the studio and there is no simple way to see all the report run details at one place i created this report in Report Studio(8.4) that Unions and gives you report run details from studios and total number of reports run in past 24hrs,reports run by the report executor,number of people running reports. The naming convension on the Data items are different than the default audit package. You can also implement this as a one of solution in the model. <report xmlns=" http://developer.cognos.com/schemas/report/6.0/ " expressionLocale="en-us">  <modelPath>/content/package[@name='BI MetaData']/model[@name='model']</modelPath>  <drillBehavior modelBasedDrillThru="true"/>  <queries>   <query name="Adhoc Reports">    <source>     <model/>    ...
Read more