[Mondrian] IIF and Filter function parameters

Thiyagu Palanisamy tpalanis at thoughtworks.com
Tue Apr 3 12:42:03 EDT 2007


The iif function in MSAS takes in variant type in second and third 
parameter whereas mondrian iif function only takes in 
<string, string> or <number, number> as its second and third argument. 
This causes iif function calls like iif(<boolean expr>,<boolean expr>, 
<numeric expression>)
to fail. 

The same behavior is also observed in filter function. Filter function in 
MSAS takes in boolean as well as numeric expression
whereas filter function in mondrian only takes in boolean as a second 
parameter..

If we add capability to convert between boolean and other scalar types 
(string, numeric) it will take care of many of these scenarios, 

Sample mdx working with MSAS
SELECT Filter(Store.allmembers, iif(measures.profit < 400000 
,[store].currentMember.NAME = "USA", true)) on 0 FROM SALES


Thanks,
Thiyagu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070403/798d069a/attachment.html 


More information about the Mondrian mailing list