Print Page - Query Items extract from FM model

Title: Query Items extract from FM model
Post by: Ravisha on 04 Jan 2017 07:55:24 PM

Hi All,

How to extract a list of all columns (Query Items) from a Framework model into excel? Model report option doesn't help me as it has a lot of other unwanted data. Even the XML datasource connection technique doesn't work (connection fails) when trying to point to model.xml file.Kindly, please share your thoughts/solution.

Thanks in advance.

Title: Re: Query Items extract from FM model
Post by: New_Guy on 05 Jan 2017 01:47:51 PM

Hi,
The export to excel of a FM model is only possible with the 3rd party tools like Motio or BSP metamanager. You can try both the tools free for, I think 2 weeks.

And also it is possible to do it with excel using vba.

Good luck

Title: Re: Query Items extract from FM model
Post by: raj_aries81 on 09 Jan 2017 07:26:08 PM

Hi,

You can try using Excel Macro with XML DOM objects, parsing the XML Tags from model.xml file.This may not be a very straight forward approach though.

Regards
Raj

Title: Re: Query Items extract from FM model
Post by: Ravisha on 10 Jan 2017 07:52:24 PM

Thanks a lot for your replies. I'm not familiar with vba scripting. Has anyone tried this before with vba ? If so, then please share the script.

Thanks in advance.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Ravisha on 04 Jan 2017 07:55:24 PM