Merk
Tilgang til denne siden krever autorisasjon. Du kan prøve å logge på eller endre kataloger.
Tilgang til denne siden krever autorisasjon. Du kan prøve å endre kataloger.
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. |