Data Dictionary

[cognospace]

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.

[blom0344]

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

[Lynn]

You can also open that XML in Excel