OLAP DML Operators

Definition: Operator

An operator is a symbol that transforms a value or combines it in some way with another value.

Categories of operators

The OLAP DML operators fall into the categories described in the following table.

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 more information on arithmetic operators, see "OLAP DML arithmetic operators".
Assignment	An operator that you use to create an assignment statement that stores the results of an expression into an OLAP DML object. For more information on using assignment statements, see "Assigning Values to Data Objects".
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 more information on comparison operators, see "Boolean operators".
Logical	Operators that you can use to transform Boolean values using logical operations which returns a Boolean result. For more information on logical operators, see "Boolean operators".
Substitution	An operator that you can use to evaluate an expression and substitute the resulting value. For more information on the substitution operator, see "Substitution Expressions".
Conditional	Operators that you can use to select one of two values based on a Boolean condition. For more information on the substitution operator, see "Conditional Expressions".