2 Expressions and Formulas

Expressions represent data values in the syntax of the OLAP DML. This chapter describes the OLAP DML data types and operators and explains how to create and use OLAP DML expressions and how to save these expressions as formulas. It includes the following topics:

• Introducing OLAP DML Expressions

• OLAP DML Data Types

• OLAP DML Operators

• Using Workspace Objects in Expressions

• Dimensionality of OLAP DML Expressions

• Numeric Expressions

• Text Expressions

• Boolean Expressions

• Conditional Expressions

• Substitution Expressions

• Working with Empty Cells in Expressions

• Limiting Dimension Values Directly in an Expression

• Formulas