Cognos Analytics

 View Only
  • 1.  Data Module metadata information from cognos content store database

    Posted Wed March 03, 2021 09:53 PM
    Hi Team,

    I have requirement from business that they want to maintain the metadata information for a data modules.

    Does anyone knows how can I retrieve this information from content store database.

    Regards,
    Shailesh

    ------------------------------
    Shailesh Dongarekar
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module metadata information from cognos content store database

    Posted Thu March 04, 2021 02:05 PM
    Hi everyone, I got the same question.

    There is any way to query the content store to get the Framework Manager metadata and the structure of a data module?

    Regards.

    ------------------------------
    Federico Balsa
    ------------------------------



  • 3.  RE: Data Module metadata information from cognos content store database

    Posted Fri March 05, 2021 06:37 AM

    Federico Balsa – for FM, you could use the Cognos SDK to recreate the model.xml file.  Additionally, Motio can also be used to recreate the model.xml.  Some notes:

    -       In general, I try not to use the content store to retrieve any metadata as it is unreliable from version to version

    -       SDK is the best interface as it provides a layer of abstraction between you and the content store

    -       If you would like a nice tabular listing (e.g. a table that lists all query items and the source value) of an FM model, you can also run the model.xml through an XSLT.  I do this once in a while to get a dump of objects, relationships, etc... to provide to business users.  XSLT is not a perfect solution, but if there modelling standards at your shop, it is a pretty good tool

     

     

    .

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 4.  RE: Data Module metadata information from cognos content store database

    Posted Fri August 13, 2021 11:29 AM
    Hi Peter,

    Do you have any example code?
    I have this code:
    var bc2 = _cognosConnection.ContentManagerService.query(packagePath2, props, s, qo2);
    var modelXML = ((model)bc2[0]).model1;

    Its working fine with previous version of cognos, but its not working with 11.1.7, model1 property is null, always.
    Do you know any different solutions?

    model object doesnt have getModel method.

    Version Infos:
    Manifest=casrv-manifest-11.1.7-2012081900-winx64h.json
    Installer=analytics-installer-2.0.20100517-win.exe

    Product_version=11.1 R7 (LTS)

    CAMAAA_ACM_version=11.1.7-20
    CAMAAASA_version=11.1.7-21
    CAMAAAW_version=11.1.7-21
    CAMAAAWA_version=11.1.7-21
    CM_version=11.1.7-47

    ------------------------------
    Ali KEÇE
    ------------------------------



  • 5.  RE: Data Module metadata information from cognos content store database

    Posted Fri March 05, 2021 09:20 AM
    Senturus has built a tool called "Report Insights", which consists of a Data Extraction Utility that pulls Cognos metadata into a database and a Cognos Data Module with associated reports.  End-users view Report Insights reports from within Cognos.

    Report Migration Tool for Cognos, Power BI, Tableau (senturus.com)

    There are many use cases for this including:

    • Capturing user impact when migrating data sources to new systems
    • Unraveling complex Cognos reports through the modeling layer to source data systems so models and reports can be rebuilt, either in Cognos Data Modules or other BI systems 
    • Creating an inventory of report and model assets, along with usage information, to better inform decisions around migration or upgrade efforts
    • Assisting with rationalizing user licenses based on number and types of reports run



    ------------------------------
    Todd Schuman
    ------------------------------



  • 6.  RE: Data Module metadata information from cognos content store database

    Posted Tue March 09, 2021 05:52 PM
    Good Evening Federico,

    I hope that all is going well on your end.  I recommend that you create a "view" within your SQL Server data source.  Create a view of something like this:
    SELECT * FROM INFORMATION_SCHEMA.COLUMNS

    Then, reference that "view" within Framework Manager as a Query Subject and treat it like any other Query Subject.  It's that simple.  It results in a dynamic result.

    Warm Regards,
    Eli





  • 7.  RE: Data Module metadata information from cognos content store database

    Posted Fri August 13, 2021 11:37 AM
    Hi Shailesh,

    Cognos Content DB have data module metadata, but its encrypted.
    1. Find Data Module CMID
    2. Put Data Module CMID as PCMID, u can copy prev sql.
    3. Get Data Module children's cmids
    4. seacrh in prop tables with these cmids.

    U can find encrypted metadata information.

    ------------------------------
    Ali KEÇE
    ------------------------------



  • 8.  RE: Data Module metadata information from cognos content store database

    Posted Mon August 16, 2021 03:24 AM
    CA SDK sample <cognos>\sdk\java\ContentStoreExplorer shows Data Module encrypted info.

    You can customise just to show Data Module info.

    Regards,
    Sheran Hettiarachchi

    ------------------------------
    Sheran Hettiarachchi
    ------------------------------