COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: mariyana on 15 May 2007 03:19:49 AM

Title: how to retrive the filter details into Excel
Post by: mariyana on 15 May 2007 03:19:49 AM
I am actually working on extracting all the details related to reports: such as extracting the group , sort,filter details into a seperate a excel sheet.

If someone knows the methods that is to be used to retrive do guide me. Its very urgent.
Title: Re: how to retrive the filter details into Excel
Post by: cognosfreelancer on 15 May 2007 02:48:19 PM
I am not aware of any functionality within Impromptu to do this for you.

You could Envisn tools for this purpose.

You could also write a VB or Cognos Script app that will extract this information and write to Excel

NKT
Title: Re: how to retrive the filter details into Excel
Post by: mariyana on 15 May 2007 10:32:10 PM
ok atleast help me with the scripts if anything is available so that i can try with that. i have retrived the details for catalogs using methods and so thought that there will be similar methods to retrive for reports also   ::)
Title: Re: how to retrive the filter details into Excel
Post by: COGNOiSe administrator on 17 May 2007 03:24:28 AM
Check Cognos Macro documentation.