title
MDX Operator Reference (MDX) | Microsoft Docs
ms.custom
ms.date
03/02/2016
ms.prod
sql-server-2016
ms.reviewer
ms.suite
ms.technology
ms.tgt_pltfrm
ms.topic
language-reference
dev_langs
helpviewer_keywords
Multidimensional Expressions [Analysis Services], operators
operators [MDX]
MDX [Analysis Services], operators
ms.assetid
1cdb8c31-a5f6-4430-b509-f81344f4622a
caps.latest.revision
34
author
Minewiskan
ms.author
owend
manager
erikre
MDX Operator Reference (MDX) [!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md ]
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.
MDX Language Reference (MDX)