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

Filtering a list report - does this HAVE to be done in the query?

Started by psrpsrpsr, 07 Apr 2017 08:06:25 AM

Previous topic - Next topic

psrpsrpsr

I have a list of ~1,500 values, like this:

LocationId  ActionCount  % of Total
1234          0                     0
5432          0                     0
9875          5                     7.4%
6657          3                     4.2%

I know that I can filter the output in the query itself (% of Total = 0), but I'm wondering:
1.) CAN I filter values by filtering in/on the list object itself?
2.) Can I create a variable that would achieve this? Would I want to?

I have experience with WebI, where it is very easy to create variables that then modify your dynamic 'queries'. I've found Cognos to be less clear in this way, and the IBM documentation sucks.

Thanks for your input

New_Guy

Hi,
You cannot filter on the List itself you have to do this at the query level. One option is to have the prompts on the list page itself.
Good luck
New guy

hespora

That is not entirely correct.

If you choose to create an active report rather than a static report, List objects in that can be dynamically filtered through freely definable report interaction.