The "case..when..then.." instruction in MDX ?

[TheHungarian]

Hi,

I just cannot find the correct syntax... The idea is to replace several iif() by something like that :

with
member measures.test as
'case commercial.currentmember.level.ordinal
when 1 then measures.quantity
when 2 then measures.sales
else measures.budget
end'
select
{measures.test} on 0,
{descendants(commercial.[All commercials],1,self_and_after)} on 1
from Cube1
where (time.[2005])

Any idea ?

 

[piemash]

if you are using Microsoft, it doesnt work (even though msdn tells you how to use it)...

Switch does not work either, yet. found any other ways around it ?

 

[TheHungarian]

Yes :

http://www.tek-tips.com/viewthread.cfm?qid=1046403&page=2