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)
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.