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?
Filter Error
-
- Posts: 15
- Joined: Wed Oct 13, 2010 6:09 am
- OLAP Product: COGNOS
- Version: 9.4
- Excel Version: 2003