One query, 2 pages - different filters

[lonas]

Hi,
I'm new in Cognos - I was working in Business Objects.
I have 2 tabs on my report - based on one query -
In first report tab I need filter different than on tab 2.
How can I achive this?

In BO I could create filter on report level for particular tab - how about Cognos?

[Lynn]

I'm not sure what you are referring to by "tabs", but sounds like a query reference might do the trick.

http://www.cognoise.com/index.php?topic=12032.0

[lonas]

this is what I need :) many thanks!

[lonas]

one more question is - are we sure that at the end there is only ONE query to DB  and my query reference are working on these results?

[Lynn]

Nope. There will be multiple queries sent to the database.

[lonas]

so how can I achive to send only one query and use resultset on different pages with different filters?

I'm retriving data from procedure.

[blom0344]

I think that is essentially the drawback of webbased reporting. Way back when full client reporting software had the advantage of building many different report (layouts, filtered sets) on the same retrieved dataset.  Those were happy days   ;)

[lonas]

I solve this issue hidding rows based on conditional boolean variable like here: https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014221133