OLAP DML Operators |
An operator is a symbol that transforms a value or combines it in some way with another value. Table: OLAP DML Operators describes the categories of OLAP DML operators.
OLAP DML Operators
| Category | Description |
|---|---|
| Arithmetic | Operators that you can use in numeric expressions with numeric data to produce a numeric result. You can also use some arithmetic operators in date expressions with a mix of date and numeric data, which returns either a date or numeric result. For a list of arithmetic operators, see "Arithmetic Operators". For more information on numeric expressions, see "Numeric Expressions" |
| Assignment | An operator that you use to assign the results of an expression into an object or to assign a value to an OLAP DML option. For more information on using assignment statements, see "Assignment Operator", SET, and SET1. |
| Comparison | Operators that you can use to compare two values of the same basic type (numeric, text, date, or, in rare cases, Boolean), which returns a BOOLEAN result. For a list of comparison operators, see "Comparison and Logical Operators". For more information on BOOLEAN expressions, see "Boolean Expressions".
|
| Conditional | The IF...THEN...ELSE operators that you can use to select one of two values based on a BOOLEAN condition. For more information on the conditional operator, see Table: Comparison and Logical Operators. For more information on conditional expressions, see "Conditional Expressions".
|
| Logical | Operators that you can use to transform BOOLEAN values using logical operations, which returns a BOOLEAN result. For a list of logical operators, see "Comparison and Logical Operators". For more information on BOOLEAN expressions, see "Boolean Expressions".
|
| Substitution | The & (ampersand) operator that you can use to evaluate an expression and substitute the resulting value. For more information on the substitution operator, see "Substitution Expressions".
|