Hi All,
I am trying to write a MDX expression to replicate a relational Case statement.
the below is the Case statement which i have been trying to replicate using MDX, the STATE and PRODUCT are in two seperate dimensions of their own.
case
when STATE = 'FL' and PRODUCT IN ( '284', '257' , '342' ) THEN ( 0 )
when STATE = 'VA' and PRODUCT = '554' THEN ( 0 )
else AMOUNT
end
any suggestions would be greatly appreciated.