ELSE CONDITION IN MDX

Hi, I'll appreciate your help to solve my develop problem.
I need to use a conditional expresion to assign a calculated member
value to cube members. I can't use the IIF function because I have 3
possible values (eg A,B,C). How can I implement the "ELSE" condition? In
pseudocode y say:
if x<=10 'A'
else if (x>10 and x<= 50) 'B'
else 'C'
Thankyou, regards,
Luis.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can nest the IIF statements
pseudo-code
IIF(x<10, 'A',(IIF(x<=50,'B', 'C'))
Sean
Sean Boon
SQL Server BI Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Luis Chiappara" <chappa@.montevideo.com.uy> wrote in message
news:%2393AGkVKEHA.808@.tk2msftngp13.phx.gbl...
> Hi, I'll appreciate your help to solve my develop problem.
> I need to use a conditional expresion to assign a calculated member
> value to cube members. I can't use the IIF function because I have 3
> possible values (eg A,B,C). How can I implement the "ELSE" condition? In
> pseudocode y say:
> if x<=10 'A'
> else if (x>10 and x<= 50) 'B'
> else 'C'
> Thankyou, regards,
> Luis.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!