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

See Also

Reference

MDX Operator Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance