![]() Previous |
![]() Next |
An OLAP DML expression has a data type and can also have dimensions. You can use expressions as arguments in statements. An expression often performs a mathematical or logical operation. It always evaluates to a result in a workspace data type.
An expression can be:
A literal value. For example, 10
or 'East'
An analytic workspace object that contains multiple values. For example, the variable sales
A function that returns one or more values. For example, TOTAL or JOINLINES
Another expression that combines literal values, dimensions, variables, formulas, and functions with operators. For example, inflation*1.02
You can save an expression as a formula as described in "OLAP DML Formulas"