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

Filter syntax

Started by Bhambry, 06 Dec 2007 08:21:41 AM

Previous topic - Next topic

Bhambry

Hi Cog Nerds!,

Ppl I need help on understanding the following expression definition used in a Filter:

([Presentation Layer].[Survey].[Survey Region Code] in (?par_Srvy_Reg?) and (?par_static_8?) = '1' and (?par_static_6?) = '2')

To the best of my understanding the above definition implies:

if ( (?par_static_8?) = '1' and (?par_static_6?) = '2') )
then ([Presentation Layer].[Survey].[Survey Region Code] in (?par_Srvy_Reg?) )

Please help me confirm if my understanding is correct. Moreover I am unable to understand how with 3 and conditions an if and else is being implemented.

Any help would be appreciated.

Thanks in anticipation.

almeids

An if...else is not being implemented, not sure why you're saying both that you understand it is and don't understand why it is.
All three conditions in your example must be met for a record to qualify.  If any of the three conditions is not met the record will not qualify.