<br><font size=2 face="sans-serif">The iif function in MSAS takes in variant
type in second and third parameter whereas mondrian iif function only takes
in </font>
<br><font size=2 face="sans-serif"><string, string> or <number,
number> as its second and third argument. This causes iif function calls
like iif(<boolean expr>,<boolean expr>, <numeric expression>)</font>
<br><font size=2 face="sans-serif">to fail. </font>
<br>
<br><font size=2 face="sans-serif">The same behavior is also observed in
filter function. Filter function in MSAS takes in boolean as well as numeric
expression</font>
<br><font size=2 face="sans-serif">whereas filter function in mondrian
only takes in boolean as a second parameter..</font>
<br>
<br><font size=2 face="sans-serif">If we add capability to convert between
boolean and other scalar types (string, numeric) it will take care of many
of these scenarios, </font>
<br>
<br><font size=2 face="sans-serif">Sample mdx working with MSAS</font>
<br><font size=2 face="sans-serif">SELECT Filter(Store.allmembers, iif(measures.profit
< 400000 ,[store].currentMember.NAME = "USA", true)) on 0
FROM SALES</font>
<br>
<br>
<br><font size=2 face="sans-serif">Thanks,</font>
<br><font size=2 face="sans-serif">Thiyagu</font>