> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# List of Supported MDX Operators by Atoti

This table lists all existing MDX Operators functions and details their support level in Atoti.

The following notations are used:

| Symbol                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Meaning               |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- |
| <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | fully supported       |
| <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/add.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=e144df45b8e2cf88dc1a402270eb6950" alt="plus" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/add.svg" />                                                  | partially supported   |
| <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/forbidden.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=1b5798b42ba2fda6004d317a8e6886a5" alt="minus" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/forbidden.svg" /> | not supported         |
| <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/error.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=759d4450d79c1138a8092bdbd10efcf4" alt="cross" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/error.svg" />                                 | will not be supported |

| Operator Name                 | Support                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Documentation & Comments                                                                                             |
| ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------- |
| + (Add numbers)               | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN + (Add) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/add-mdx)                                               |
| + (Positive numbers)          | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/forbidden.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=1b5798b42ba2fda6004d317a8e6886a5" alt="minus" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/forbidden.svg" /> | [MSDN + (Positive) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/positive-mdx)                                     |
| / (Divide numbers)            | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN Divide - MDX Operator Reference](https://docs.microsoft.com/en-us/sql/mdx/divide-mdx-operator-reference)       |
| \* (Multiply numbers)         | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN \* (Multiply) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/multiply-mdx)                                    |
| - (Subtract numbers)          | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN - (Subtract) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/subtract-mdx)                                     |
| - (Negative numbers)          | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN - (Negative) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/negative-mdx)                                     |
| ^ (Power numbers)             | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN ^ (Power) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/power-mdx)                                           |
| AND                           | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/add.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=e144df45b8e2cf88dc1a402270eb6950" alt="plus" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/add.svg" />                                                  | [AND and OR Operators (MDX)](#and-and-or-operators)                                                                  |
| IS                            | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN IS (MDX)](https://docs.microsoft.com/en-us/sql/mdx/is-mdx)                                                     |
| NOT                           | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN NOT (MDX)](https://docs.microsoft.com/en-us/sql/mdx/not-mdx)                                                   |
| OR                            | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/add.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=e144df45b8e2cf88dc1a402270eb6950" alt="plus" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/add.svg" />                                                  | [AND and OR Operators (MDX)](#and-and-or-operators)                                                                  |
| XOR                           | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN XOR (MDX)](https://docs.microsoft.com/en-us/sql/mdx/xor-mdx)                                                   |
| : (Range)                     | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN : (Range) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/range-mdx)                                           |
| \< (Less Than)                | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN \< (Less Than) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/less-than-mdx)                                  |
| \<= (Less Than or Equal To)   | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN \<= (Less Than or Equal To) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/less-than-or-equal-to-mdx)         |
| \<> (Not Equal To)            | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN \<> (Not Equal To) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/not-equal-to-mdx)                           |
| = (Equal To)                  | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN = (Equal To) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/equal-to-mdx)                                     |
| > (Greater Than)              | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN > (Greater Than) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/greater-than-mdx)                             |
| >= (Greater Than or Equal To) | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN >= (Greater Than or Equal To (MDX)](https://docs.microsoft.com/en-us/sql/mdx/greater-than-or-equal-to-mdx)     |
| - (Except sets)               | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN Except (MDX) Operator](https://docs.microsoft.com/en-us/sql/mdx/except-mdx-operator)                           |
| + (Union sets)                | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN Union - MDX operator reference](https://docs.microsoft.com/en-us/sql/mdx/union-mdx-operator-reference)         |
| \* (Crossjoin sets)           | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN Crossjoin - MDX Operator Reference](https://docs.microsoft.com/en-us/sql/mdx/crossjoin-mdx-operator-reference) |
| + (Concatenate strings)       | <img src="https://mintcdn.com/activeviam/KszPZqdDnmT6EpJc/engine/java-sdk/6.1/assets/mdx/check.svg?fit=max&auto=format&n=KszPZqdDnmT6EpJc&q=85&s=8e077caa27c8997138897bea9c36f751" alt="tick" width="16" height="16" data-path="engine/java-sdk/6.1/assets/mdx/check.svg" />                                  | [MSDN + (String Concatenation) (MDX)](https://docs.microsoft.com/en-us/sql/mdx/string-concatenation-mdx)             |

### And and Or Operators

The `AND` and `OR` operators follow the MSDN specification ([AND](https://docs.microsoft.com/en-us/sql/mdx/and-mdx), [OR](https://docs.microsoft.com/en-us/sql/mdx/or-mdx)), 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.
