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 upported | |
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) | |
- (Substract 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) | |
<> (No 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.