Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: momoreed on 12 Nov 2015 03:15:55 PM

Title: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 12 Nov 2015 03:15:55 PM
Hello!

I am wondering if anyone has found a way to export all of the Framework fields (Query Subjects, Folders, Namesspaces, etc.) into an Excel or Word document?

We currently have a source that has around 1200 different fields...and I am handtyping them out to put together a Dictionary of Terms for my company. 

I'm thinking there must be an easier way to export these fields into Excel or something. 

I only have access to Query Studio and Report Studio...but I can go to a different department to gain access to Framework Manager if need be. 

Any ideas would be so greatly appreciated!!!!! 

Lindsay Becvar
860-687-5007
LindsayM.Becvar@kaman.com
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: cognostechie on 12 Nov 2015 03:46:25 PM
Framework Manager can export all fields (query items) and folders into a csv file which can be opened in EXCEL.
Project Menu > Languages > Export Translation File
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 13 Nov 2015 07:46:29 AM
Wow....thank you so much!  I sent this "How To" information to the person who has access to Framework Manager within my company.  Hopefully they are successful in exporting those items.  Thank you, thank you, thank you!  Happy Friday!
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: cognostechie on 13 Nov 2015 11:39:19 AM
You are very welcome !  :)
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 13 Nov 2015 12:43:38 PM
Hello again,

May I ask one more question?

We were able to export...but had to do a separate export for each dimension. 

Do you know if there is a way to get all the columns into one sheet, and have them sorted by query subject?

Thanks again!

Lindsay Becvar
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 13 Nov 2015 12:59:32 PM
To give an example of the format we are receiving....the 4 folders we have within one particular dimension are appearing at the very top of the data.  It would be so great if the actual folder appeared to the left or right of the query subject.  But, is that getting too complicated on this type of export?

en
Attributes                            THIS IS A FOLDER
Codes and Type                   THIS IS A FOLDER
Dates                                  THIS IS A FOLDER
Flags                                   THIS IS A FOLDER
WP ABC Chg Dt                     QUERY SUBJECT
WP ABC Cust Class Expire Dt  QUERY SUBJECT
WP ABC GMROI Class              QUERY SUBJECT

What would be great:

WP ABC Chg Dt                        DATE
WP ABC Cust Class Expire Dt     DATE

Any thoughts?

Thanks so much!

Lindsay Becvar
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: cognostechie on 13 Nov 2015 01:37:27 PM
Unfortunately, that is not possible, at least with this method. Maybe somebody else knows of another way to achieve this and will post here.
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 13 Nov 2015 01:43:02 PM
O.K.  Thanks!  Just thought I would ask.  Are there other methods you use to export this type of information? 
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: cognostechie on 13 Nov 2015 01:46:22 PM
That's the only one I have used.
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: Lynn on 16 Nov 2015 05:30:03 AM
You can run a model report and then save the XML and then open it in Excel. It is pretty ugly and very wide but might give you some other options to consider.
Title: Re: Printing the Framework Tree (Query Subject, Folders, Namespaces, etc.)
Post by: momoreed on 16 Nov 2015 09:51:33 AM
Thank you!  We'll try this!    :)
Text only | Text with Images