List of Supported MDX Operators by ActivePivot
This table lists all existing MDX Operators functions and details their support level in ActivePivot.
The following notations are used:
| Symbol | Meaning |
|---|---|
 | fully supported |
 | partially supported |
 | not supported |
 | will not be supported |
| Operator Name | Support | Documentation & Comments |
|---|---|---|
| + (Add numbers) | | MSDN + (Add) (MDX) |
| + (Positive numbers) | | MSDN + (Positive) (MDX) |
| / (Divide numbers) | | MSDN Divide - MDX Operator Reference |
| * (Multiply numbers) | | MSDN * (Multiply) (MDX) |
| - (Subtract numbers) | | MSDN - (Subtract) (MDX) |
| - (Negative numbers) | | MSDN - (Negative) (MDX) |
| ^ (Power numbers) | | MSDN ^ (Power) (MDX) |
| AND | | AND and OR Operators (MDX) |
| IS | | MSDN IS (MDX) |
| NOT | | MSDN NOT (MDX) |
| OR | | AND and OR Operators (MDX) |
| XOR | | MSDN XOR (MDX) |
| : (Range) | | MSDN : (Range) (MDX) |
| < (Less Than) | | MSDN < (Less Than) (MDX) |
| <= (Less Than or Equal To) | | MSDN <= (Less Than or Equal To) (MDX) |
| <> (Not Equal To) | | MSDN <> (Not Equal To) (MDX) |
| = (Equal To) | | MSDN = (Equal To) (MDX) |
| > (Greater Than) | | MSDN > (Greater Than) (MDX) |
| >= (Greater Than or Equal To) | | MSDN >= (Greater Than or Equal To (MDX) |
| - (Except sets) | | MSDN Except (MDX) Operator |
| + (Union sets) | | MSDN Union - MDX operator reference |
| * (Crossjoin sets) | | MSDN Crossjoin - MDX Operator Reference |
| + (Concatenate strings) | | MSDN + (String Concatenation) (MDX) |
And and Or Operators
The AND and OR operators follow the MSDN specification (AND, OR), with one difference: the arguments are lazily evaluated.
For example when doing arg1 AND arg2, if arg1 evaluates to false, arg2 won't be evaluated. Similarly, for the expression arg1 OR arg2, if arg1 evaluates to true, arg2 won't be evaluated.