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.

In This Section

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.

See Also

Concepts

MDX Language Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance