Hi,
I have tried a case statement but got the following error.
QE-DEF-0459 CCL Exception
QE-DEF-0260 Parsing error.....
My case statement as follows. This is written inside a set expression. Also the parameter ?pstyle? contatins static values from 1 to 5.
CASE
WHEN ?pstyle?= 2 THEN periodsToDate ([Package].[Calendar].[Calendar].[Month], [Selected Week])
WHEN ?pstyle?= 3 THEN periodsToDate ([package].[Calendar].[Calendar].[Quarter], [Selected Week])
WHEN ?pstyle?= 4 THEN periodsToDate ([package].[Calendar].[Calendar].[Year], [Selected Week])
ELSE [Selected Week])
END
Note: my source is a cube
Can anybody help me for this
Many thanks,
UG
Hi
In the else part of your statement you seem to have a closed parenthesis but no open parenthesis. This may not solve your problem but it will help you to close in on it.
Hope this helps
Abu