Data Mining Extensions (DMX) Operator Reference
The Data Mining Extensions (DMX) language in Microsoft SQL Server Analysis Services supports arithmetic, assignment, comparison, logical, and unary operators. The following table lists the operators that DMX supports.
Operator |
Description |
|---|---|
An arithmetic operator that adds two numbers together. |
|
An arithmetic operator that subtracts one number from another number. |
|
An arithmetic operator that multiplies one number by another number. |
|
An arithmetic operator that divides one number by another number. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is less than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is greater than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is not equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is less than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is greater than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value. |
|
A logical operator that performs a conjunction on two numeric expressions. |
|
A logical operator that performs a negation on a numeric expression. |
|
A logical operator that performs a disjunction on two numeric expressions. |
|
A unary operator that returns the positive value of a numeric expression. |
|
A unary operator that returns the negative value of a numeric expression. |
|
Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line. |
|
Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line. |
|
Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line. |
See Also
Reference
Data Mining Extensions (DMX) Function Reference
Data Mining Extensions (DMX) Reference
Data Mining Extensions (DMX) Statement Reference
Data Mining Extensions (DMX) Syntax Conventions