IS (MDX)

Performs a logical comparison on two object expressions.


Expression1 IS ( Expression2 | NULL )

Expression1

A valid Multidimensional Expressions (MDX) expression that returns an MDX object reference.

Expression2

A valid MDX expression that returns an MDX object reference.

A Boolean value that returns true if both arguments refer to the same object; otherwise, false. If the NULL keyword is specified, the operator returns true if Expression1 is null; otherwise, false.

The IS operator is often used to determine whether tuples and members are idempotent.

The following example returns false if Time.[1996] is non-null:

Time.[1996] IS NULL

Community Additions

ADD
Show: