Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Export Metadata Information

    Posted Fri August 07, 2020 07:55 AM
    Hi All,

    Is there any way of exporting meta data information in tabular format for cognos FM packages. I want to know details like Query subject name, Query items, and there technical name.

    I am aware about "Export model" option in framework manager but it gives you an output in xml.


    Please let me know if anyone is aware of any option within cognos or using some third party tool.


    Thanks& Regards,
    Shailesh D

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

    #CognosAnalyticswithWatson


  • 2.  RE: Export Metadata Information

    Posted Mon August 10, 2020 01:34 AM
    Edited by System Admin Fri January 20, 2023 04:51 PM
    In Motio PI Professional there is an option to export contents of a package or the entire CPF model file and it shows objects within all levels of the hierarchy down to query item level.

    This functionality should be available within the free version.

    ------------------------------
    Mark Peterson
    ------------------------------

    Original Message


  • 3.  RE: Export Metadata Information

    Posted Mon August 10, 2020 03:31 AM
    Perhaps the build-in feature of Framework Manager to document the model is another alternative:
    Creating model documentation

    #CognosAnalyticswithWatson


  • 4.  RE: Export Metadata Information

    Posted Tue August 11, 2020 08:03 AM

    All – yes, there is a way to get a tabular view of all objects within an FM Model.  What you have to do is run your model.xml through an xslt, this will render the objects in tabulr format in a web browser, which you can then copy and paste into a spreadsheet or text document

     

    The only challege is since there are so many variants on how developers develop, the xslt in general works only on one model.xml.  So what we enforce at our shop is making sure all developers develop with a certain style (e.g. Relational versus DMR), having only certain namespaces, etc...

     

    If you have a small model that you can share, I can develop an xslt for you.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     




    Original Message


Related Content