COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: cognospace on 24 Apr 2013 04:18:17 PM

Title: Data Dictionary
Post by: cognospace on 24 Apr 2013 04:18:17 PM
Frist time posting on cognoise...

I've been asked to create a data dictionary for our Query Studio end users.  Currently we do have some tooltip descriptions in place for data items.  Is there a way to extract the subject, data item and tooltip descriptions from the business layer of the FM?  We're not in a position to purchase any additional software that would help with the task.


Title: Re: Data Dictionary
Post by: blom0344 on 25 Apr 2013 03:05:42 AM
Everything you need is stored within the model.xml file of the FM model, but the tricky part is to get it out in a properly fashion. The interesting part is in the namespace part of the XML where each model query subject is stored between   the tags:
<querySubject status="valid">    .......................    </querySubject>
each item is stored between:
<queryItem>  .................   </queryItem>
The same is attainable by running a model report from FM and using the xml option. You need to use a good editor (Ultraedit / Notepad++) to rework the xml and use an xml to text editor to brake the xml to a flat text file



Title: Re: Data Dictionary
Post by: Lynn on 25 Apr 2013 08:34:26 AM
You can also open that XML in Excel