| Iif | (standard MDX) |
Evaluates the logical expression; if true returns the first expression, the second expression otherwise.
Parameters
| Name | Type | Cardinality | Default value |
| condition | logical-expression | one | |
| true-expression | expression | one | |
| false-expression | expression | one |
Return
set
Description
The IFF function first evaluates the logical expression :
a) if true, returns the first expression.
b) if false (or NULL), returns the second expression.
The returned expressions can be any valid MDX expressions (numeric, strings, sets, tuples).
Examples
Special Examples (errors, null, ...)
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.
icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT