MDX Operator Reference (MDX)

The Multidimensional Expressions (MDX) language supports arithmetic, logical, comparison, set, string, and unary operators. The following table lists the supported operators and their descriptions.

Topic

Description

-- (Comment) (MDX)

Indicates comment text that is provided by the user.

- (Except) (MDX)

Performs a set operation that returns the difference between two sets, removing duplicate members.

- (Negative) (MDX)

Performs a unary operation that returns the negative value of a numeric expression.

- (Subtract) (MDX)

Performs an arithmetic operation that subtracts one number from another number.

* (Crossjoin) (MDX)

Performs a set operation that returns the cross product of two sets.

* (Multiply) (MDX)

Performs an arithmetic operation that multiplies two numbers.

/ (Divide) (MDX)

Performs an arithmetic operation that divides one number by another number.

^ (Power) (MDX)

Performs an arithmetic operation that raises one number by another number.

/*...*/ (Comment) (MDX)

Indicates comment text that is provided by the user.

// (Comment) (MDX)

Indicates user-provided text.

: (Range) (MDX)

Performs a set operation that returns a naturally ordered set, with the two specified members as endpoints, and all members between the two specified members included as members of the set.

+ (Add) (MDX)

Performs an arithmetic operation that adds two numbers.

+ (Positive) (MDX)

Performs a unary operation that returns the positive value of a numeric expression.

+ (String Concatenation) (MDX)

Performs a string operation that concatenates two or more character strings, tuples, or a combination of strings and tuples.

+ (Union) (MDX)

Performs a set operation that returns a union of two sets, removing duplicates.

< (Less Than) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is less than the value of another MDX expression.

<= (Less Than or Equal To) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is less than or equal to the value of another MDX expression.

<> (Not Equal To) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is not equal to the value of another MDX expression.

= (Equal To) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is equal to the value of another MDX expression.

> (Greater Than) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is greater than the value of another MDX expression.

>= (Greater Than or Equal To) (MDX)

Performs a comparison operation that determines whether the value of one MDX expression is greater than or equal to the value of another MDX expression.

AND (MDX)

Performs a logical conjunction on two numeric expressions.

IS (MDX)

Performs a logical comparison on two object expressions.

NOT (MDX)

Performs a logical negation on a numeric expression.

OR (MDX)

Performs a logical disjunction on two numeric expressions.

XOR (MDX)

Performs a logical exclusion on two numeric expressions.

Community Additions

ADD
Show: