Query Items extract from FM model

[Ravisha]

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.

[New_Guy]

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

[raj_aries81]

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

[Ravisha]

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.