fbpx

Operators (MDX)

The following table lists the available operators and their descriptions.

Description


Comparison


Equal To (=) Compare two MDX expressions:
NULL = false is true
NULL = 0 is true

Not Equal To (<>) Compare two MDX expressions:
NULL <> false is false
NULL <> 0 is false

Less Than (<) Compare two MDX expressions.

Less Than or Equal To (<=) Compare two MDX expressions.

Greater Than (>) Compare two MDX expressions.

Greater Than or Equal To (>=) Compare two MDX expressions.


Comparison (Strict)


Equal To (==) Similar to the 'Equal To' operator except that:
NULL == false is false
NULL == 0 is false

Not Equal To (!=) Similar to the 'Not Equal To' operator except that:
NULL != false is true
NULL != 0 is true

Less Than (<<) Similar to the 'Less Than' operator except that:
0, false, "" are not considered as NULL

Less Than or Equal To (<<=) Similar to the 'Less Than or Equal To' operator except that:
0, false, "" are not considered as NULL

Greater Than (>>) Similar to the 'Greater Than' operator except that:
0, false, "" are not considered as NULL

Greater Than or Equal To (>>=) Similar to the 'Greater Than or Equal To' operator except that:
0, false, "" are not considered as NULL


Logical


And (AND) Logical and operation.

Or (OR) Logical or operation.

Not (NOT) Logical not operation.

Xor (XOR Logical xor operation.

Is (IS) Same MDX entities (www).



Mathematical


Add (+) Adds two scalar entities. Note that string entities are concatenated.

Subtract (-) Subtracts two scalar entities or unary negative operator.

Multiply (*) Multiplies two scalar entities.

Divide (/) Divides two scalar entities.

Power (^) Raises one scalar entity by a number.



Others


Crossjoin (*) Cross product of two sets (www).

Except (-) Difference between two sets (www).

Union (+) Union of two sets removing duplicates (www).

Range (:) A set of members between two members (www).



See Also

Crossjoin Except Range Operator Is Operator

XMLA Properties

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