Changing the Filter Display in Query Studio

[sraj1]

Is there a way to change the Filter reference for Query Studio Reports.

For example I have a report which pulls data from table A and I want to apply filter on one particular Item. Usually when I apply Filter, Table A is scanned for distinct values and then Displayed under "Pick values from a list". If the table is very big then this takes a long time.

Now I have a seperate table, which contains the values for the filter. So was wondering if there is a way where I can point the Filter to actually look at the Filter Table for displaying the values rather than scanning the Huge original table.

 

[CognosProfessional]

Yes, change the property that you are using to get the data for that filter to use your new separate table instead.

CP

 

[sraj1]

Can you elobrate a bit on the Propert change. What property and where to change?

 

[kennedydottie]

in teh queries section, you can view the properties of the query you are referring to (the one you want to change), look for the Query property.... in that drop down box you should see your new query that you wish to use... change it there.

 

[sraj1]

I know how to change for one report at a time.. I am looking for changing all of the report at a time (Batch).

 

[AngelaCognos]

Cognos has a tool called DRU that is a mass find/replace (it scares me).

http://www-01.ibm.com/support/docvi...swg24021248&loc=en_US&cs=utf-8&cc=us&lang=all

Brightstar Partners has a tool called MetaManager that can do it, too.

http://www.brightstarpartners.com/bspsoftware.php