Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Extract Business model fields and expression definitions

    Posted 12/18/19 12:10 PM
    In Framework Manager I can see all the field names and on a individual basis go in and look at the Expression definitions. I was wondering if there is anyway to extract a list of all the fields in a business model and the expression definition?

    ------------------------------
    Tim Crowdis
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Extract Business model fields and expression definitions

    Posted 12/19/19 03:22 AM
    Framework Manager has a model documentation option should be convenient here.
    It's under Tools menu and called Model Report.
    A short description can be found here:
    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_createmodeldocumentation.html#CreateModelDocumentation

    #CognosAnalyticswithWatson


  • 3.  RE: Extract Business model fields and expression definitions

    Posted 12/19/19 07:21 AM
    Edited by System Admin 01/20/23 04:48 PM
    We have a c# solution that reads the model.xml and extracts the field names, type, expression, description (release add, release modify, corresponding host field name),etc and inserts it into a table. This is very handy because we have a Cognos report written off of the table so that the client can search for fields based on any of this criteria​. Obviously I cannot share the solution, but it is all in the model.xml and someone with some pretty basic c# (vb.net, powershell, etc) skills could extract this data for you)

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