DeepSee MDX Reference
IIF
|
|
IIF(check_expression, expression1, expression2)
SELECT IIF(MEASURES.[%COUNT]<500, "fewer than 500", "500 or more") ON 0, diagd.MEMBERS ON 1 FROM patients IIF 1 None 500 or more 2 asthma 500 or more 3 CHD fewer than 500 4 diabetes 500 or more 5 osteoporosis fewer than 500
SELECT %LABEL(IIF(MEASURES.[%COUNT]<500, "fewer than 500", "500 or more"),"Patient Count") ON 0, diagd.MEMBERS ON 1 FROM patients Patient Count 1 None 500 or more 2 asthma 500 or more 3 CHD fewer than 500 4 diabetes 500 or more 5 osteoporosis fewer than 500
SELECT %LABEL(IIF(homed.h1.CURRENTMEMBER.PROPERTIES("Population")>20000,"big","small"), "Town Size") ON 0, homed.city.MEMBERS ON 1 FROM patients Town Size 1 Cedar Falls big 2 Centerville big 3 Cypress small 4 Elm Heights big 5 Juniper small 6 Magnolia small 7 Pine small 8 Redwood big 9 Spruce small
WITH MEMBER MEASURES.iif AS 'IIF(homed.CURRENTMEMBER.PROPERTIES("name")="Pine"," ", MEASURES.[%COUNT])' SELECT MEASURES.iif ON 0, homed.city.MEMBERS ON 1 FROM patients iif 1 Cedar Falls 1,120 2 Centerville 1,106 3 Cypress 1,139 4 Elm Heights 1,078 5 Juniper 1,109 6 Magnolia 1,122 7 Pine 8 Redwood 1,128 9 Spruce 1,108