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 on multi-value parameter

Started by thejav, 31 Oct 2013 11:28:53 AM

Previous topic - Next topic

thejav

I have a parameter with multiple values separated by commas (e.g. AF,AJ), i need to create a filter on a query that insures the values in a data item is in the list of values contained in the parameter.

For example, the parameter contains: AF,AJ, if the value that is in the data item (a column in a table) is AF or AJ then it should be included. If the value is anything else (e.g AFF or BF etc) then it should not be included.

How can i do this?