TechNet
Export (0) Print
Expand All

MDX Operator Reference (MDX)

 

Updated: March 2, 2016

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

TopicDescription
-- (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.

MDX Language Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft