ELSE CONDITION IN MDX -- sql server data warehouse

Luis Chiappara
4/23/2004 10:32:58 AM

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.developersdex.com ***

Sean Boon [MS]
4/23/2004 11:25:00 AM

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.

[quoted text, click to view]

sql server data warehouse : ELSE CONDITION IN MDX