fbpx

Iif (MDX)

Evaluates the logical expression; if true returns the first expression, the second expression otherwise.

Parameters

Name Type Cardinality Default value
condition  boolean-expression  one   
true-expression  expression  one   
false-expression  expression  one   

Return

any

Description

The IIF 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).

See Also

Divide DivN CoalesceEmpty CoalesceNull

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.