icCube

Documentation

CoalesceNull

(MDX)

Returns the first non-null/no-empty-set entity from the parameters list.

Parameters

Name Type Cardinality Default value
  dimension-hierarchy-level-expression  one-n   

Return

any

Description

The function returns the first non-null/no-empty-set entity among the list of parameters. The parameter
can be any olap entity, for example a member, tuple, dimension, hierarchy, scalar value...

Members and Tuples are not evalutes as in CoalesceEmpty function.

See Also

CoalesceEmpty Iif

Examples

Special Examples (errors, null, ...)

Since Version

6.0

XMLA Properties

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