If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Suppressing Query in Report Studio

Started by myd3p, 17 Dec 2009 03:40:52 PM

Previous topic - Next topic

myd3p

HI! Hope someone can guide me on how to suppress a specific query in report studio.

I have a transaction report that combines four queries into one in order to attach it to a list. There's an option that they can only print one specific transaction (e.g shipment). When you run the specific query, it executes fast but when you run the Main Qeury, the report takes a long time to run, I think it executes the whole query before filtering it by transaction. Is there a way to immediately exclude a query so that Cognos will not include it during execution? Thank you very much.

Main Query
   |--- Sub Query1 (union)
   |           |----- Query 1 (shipment)
   |           |----- Query 2 (receiving)
   |
   |--- Sub Query 2 (union)
               |----- Query 3 (production)
               |----- Query 4 (transfers)
               

angela

If I understand correctly a person picks a prompt value and it goes against ONE of the subqueries.  If that's right you could avoid the unions and use conditional rendering to know and which list to display and each list would be tied to one query.  It should avoid all the unecessary overhead.