Cognos Analytics

 View Only

  • 1.  Looking for content store information - List of Classids and list of tables with description

    Posted Tue August 27, 2024 04:35 PM

    Looking for content store information - List of Classids and their object types and list of tables with description



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------


  • 2.  RE: Looking for content store information - List of Classids and list of tables with description

    Posted Fri August 30, 2024 12:34 PM

    Surely someone must have list, even it not complete of the Cognos content store tables with descriptions and the classid codes and descriptions. 

    So far I have these, but not even sure if they are correct

    classids
    ========
    0 -- root folder
    1 -- folders
    5 -- account
    6 -- job definition
    8 -- accounts ?? HORIZON360BI:F:53781DD0BE6D014DA24B814DAC01EA83
    10 -- reports
    18 -- models
    19 -- report view
    26 -- role
    32 -- namespaces
    33 -- content
    37 -- query
    38 -- model - name for each row is "MODEL"
    52 -- deployment packages
    54 -- group
    55 -- job
    85 -- agent definition
    111 -- schedule last executed ??
    178 -- documents
    209 -- dashboards

    10, 19, 234, 257 -- jobstep stuff


    Classids - MS SQL to see objects with a specific classid
    ========================================================

    SELECT 
    cmobjnames.cmid cmid, 
    UPPER(cmobjnames.NAME) name, 
    cmobjects.classid, 
    cmobjnames.mapdlocaleid 
    FROM 
    dbo.cmobjects, 
    dbo.cmobjnames 
    WHERE 
    cmobjects.classid IN (19)   -- CHANGE THIS 
    AND cmobjnames.mapdlocaleid = 92 
    AND cmobjects.cmid = cmobjnames.cmid

    OLD list of Content Store Tables
    ================================

    Cognos Content Store Database Tables Table name   Descrition
    CMSYSPROPS   This table has the Content Store Version.   
    CMOBJNAMES   This table has the names of all the objects in the content store.   
    CMOBJPROPS1   Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table   
    CMOBJPROPS2   Report scheduling information is stored. This table has fields like hour, day week etc   
    CMOBJPROPS3   Stores Screen Tip and Object description provided while creating the objects are stored here   
    CMOBJPROPS4   Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations   
    CMOBJPROPS6   Has the details of the all packages which were published using the FM.   
    CMOBJPROPS7   This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models.   
    CMOBJPROPS10   Contact information is stored in this table. This table has columns like Contact Email and Contact.   
    CMOBJPROPS11   This table stores the data sources configuration details like connect string, the cube location etc.   
    CMOBJPROPS13   It stores the names of parameter passed to the range prompts.
    The binary value in CPARMVALUE is XML compressed with gzip.   
    CMOBJPROPS14   Has details regarding the versions, creation time etc of the objects in the content store.    
    CMOBJPROPS16   This table provides the status of the multiple services of Cognos like LogService, MonitorService, ReportService, SystemService, JobService   
    CMOBJPROPS17   Stores performance details of each component like "query Studio, Analysis Studio, Event Studio" etc    
    CMOBJPROPS18   This table stores the drill path from the source to the final target report.   
    CMOBJPROPS20   Stores details regarding which are all the reports for which prompting has been enabled. And also has the details of which are the reports which has the default report options overridden.   
    CMOBJPROPS24   Stores the printer configuration details    
    CMOBJPROPS25   Stores the data regarding the objects deployed, like the deployed folder, the reports, the number of folders present in the deployment archive, etc   
    CMOBJPROPS26   This table stores the data about all the packages imported / exported in C8, with the properties selected during the process.   
    CMOBJPROPS27   Has the details regarding the data source created in the content store using Cubes.   
    CMOBJPROPS30   Stores the registration , service description etc details about portlets in this table   
    CMOBJPROPS31   Has the custom logging level for each of the Cognos services, CMID can be be linked to CMOBJNAMES for the names of each of the services   
    CMOBJPROPS32   Has the details of the stored procedures used as the query items in the FM model.    
    CMOBJPROPS33   Detail related to users, user groups user roles.   
    CMOBJPROPS34   Has the details regarding the drill through parameters of the drill through reports. The parameter assign values are present in coded format   
    CMOBJPROPS36   Has the list of all the Models published using framework manager   
    CMOBJPROPS37   This table has the details of the routing sets configured for server / load balancing for each package published in the content store   
    CMOBJPROPS38   Configuration details about number of items to retrieve in studios, for a package are saved under this table.   
    CMOBJPROPS39   Has values for properties of reports and views. PROPID can be linked to CMPROPERTIES for property names   
    CMOBJPROPS52   Contains the properties for the connections   
    CMOBJPROPS55   Has the URI for icons for each entry in Cognos Connection   
    CMLOCALES   Has the locale ids associated with each language supported by Cognos 8  



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 3.  RE: Looking for content store information - List of Classids and list of tables with description

    Posted Mon October 07, 2024 12:59 PM

    I asked one of the Content Store developers, he shared:

    We intentionally do not document schema because we want to have a free hand modifying it when we need to.

    For internal support, people can refer to [install]/webapps/p2pd/WEB-INF/cm/cmMetadata.xml. It's relatively easy to understand. It is our master file for mapping properties to tables/columns. It also contains class ids.

    In content store, class name to class id mapping is stored in CMCLASSES table.

    This is not a secret information, of course, many "advanced" customers use it, as well as some OEM providers. But we do not provide any guarantees that formats won't change. CMCLASSES (CLASSID, NAME) table can be reasonably relied on –these two columns are unlikely to change

    I hope this helps, but use it considering the cautionary note above, that this may change without notification.



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------

    Original Message


  • 4.  RE: Looking for content store information - List of Classids and list of tables with description

    Posted Fri October 04, 2024 03:30 PM

    Last try to get someone to help me with a list of classids and the objects that each value represents. 



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 5.  RE: Looking for content store information - List of Classids and list of tables with description

    Posted Mon October 07, 2024 04:44 AM
    Edited by Thomas van der Meer Mon October 07, 2024 04:46 AM

    Hi Brenda.
    The table CMCLASSES (column NAME) has the information of all the classes with the description. 
    Just take a look at that table. Below an example to combine this table.
    Is this helpfull?
    For example:
    select 
     A.CMID
    ,A.PCMID
    ,B.NAME
    ,B.NAME as PARENT
    ,C.NAME as CONTENT
    ,cast(B.NAME as varchar(512)) as PATH
    ,0 as LEVELNR
    ,a.CLASSID
    from CMOBJECTS  A
    join CMOBJNAMES B on A.CMID = B.CMID
    join CMCLASSES  C on A.CLASSID = C.CLASSID
    where B.ISDEFAULT = 1
    and A.PCMID = 0
    and A.CMID in ( 2, 4 ) -- 2 is teamcontent, 4 is personal folders
    ;



    ------------------------------
    Thomas van der Meer
    ------------------------------

    Original Message