COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: myd3p on 17 Dec 2009 03:40:52 PM

Title: Suppressing Query in Report Studio
Post by: myd3p on 17 Dec 2009 03:40:52 PM
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)
               
Title: Re: Suppressing Query in Report Studio
Post by: angela on 18 Dec 2009 04:21:29 PM
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.