Export to excel

[samcom]

Hi,
I am tasked to create mapping documents for our project from current framework and I am wondering if we have any export functionality in framework as columns in the table are renamed in the query subject to business terms. Before I start typing manually, thought I will ask.

I am new to Cognos and could not find an export to xls where it show source and target mapping like example below.
EMP_Name   Employee Name
EMP_Type   Employment type

Thanks,
Sam.

[Rahul Ganguli]

Interesting, but I think it is not present.
Hope if somebody can tell us a solution for this.

One way is to parsing the model.xml file and getting the desired results. I have written some custom perl scripts for model.xml but they were for different purpose.

Regards,
Rahul

[Lynn]

You could run the Model Report (Tools > Model Report) to XML and then open it in Excel. Strip out all the noise and you could end up with something relatively close to what you are after. It will give you all the attributes for each query item in a separate column.

If you have query items in sub-folders it puts those in columns to the right of the main list of query items which is a little strange, but you can cut and paste to deal with that. Still might be less work than typing it all :-)

[samcom]

Thanks let me try !!