If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Find all FM models that contain certain tables

Started by StevenFiske, 05 Dec 2014 08:17:15 AM

Previous topic - Next topic

StevenFiske

We have a large number of Framework Manager models in our organization, and when tables change we need to find all models that use those tables. Does any know of a way, perhaps thru the SDK, that I can query the Content Store and find all models that use a certaing table?

cognos810

Hello StevenFiske,
I had a similar requirement once, wherein I had to find report dependencies based on a data source. What I ended up doing was:
1)Query the content store of all instances of a package and then the model within it.
2)Get the model.xml and download it to a file.
3)Then parse the model.xml to get the datasources referenced in the XML.
4)Similarly get a list of reports and the package referenced.
5)Then, tie this information together to get the data source to report mapping.

I guess, you can do the same without the report dependency part. That is, get all the model.xml files for all the packages and then parse them for existence of your table_name.

You would not need to use SDK or query the content store if you have all the FM models saved in a central location. In which case, you would simply parse the model.xml files from within the FM projects.

-Cognos810