IS (MDX)
Performs a logical comparison on two object expressions.
Syntax
Expression1 IS ( Expression2 | NULL )
Parameters
- Expression1
A valid Multidimensional Expressions (MDX) expression that returns an MDX object reference.
- Expression2
A valid MDX expression that returns an MDX object reference.
Return Value
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.
Remarks
The IS operator is often used to determine whether tuples and members are idempotent.
Examples
The following example returns false if Time.[1996] is non-null:
Time.[1996] IS NULL