Filter Error

Post Reply
keigo840413
Posts: 15
Joined: Wed Oct 13, 2010 6:09 am
OLAP Product: COGNOS
Version: 9.4
Excel Version: 2003

Filter Error

Post by keigo840413 »

Hi All,
I wrote the filter as follow:
if('Brazil' in ?Parameter1?) then
([CONTRY] in ?Parameter1?
or [CONTRY] in ('Argentina')
)
else
([CONTRY] in ?Parameter1?
)
But it prompt the error as:
UDA-QOS-0006 Syntax error near "in"

if i change the code to:
if(1=1) then
([CONTRY] in ?Parameter1?
or [CONTRY] in ('Argentina')
)
else
([CONTRY] in ?Parameter1?
)

it works fine.
Can anyone tell me why the syntax is wrong?
Post Reply