MDX Statements

<value_expression> ::= <numeric_value_expression>
                     | <string_value_expression>

Statements in MDX operate on the following basic entities:

• Set. A collection of tuple elements.

• Member. A member of a dimension.

• Tuple. A collection of members from different dimensions.

• Numeric.Can be an exact numeric, such as integer or decimal, or an approximate numeric, such as float or double.

• Time dimension. Time series functions operate on the dimension that is specified implicitly as part of their <set>, <member>, or <level> arguments.

MDX statements can perform a variety of other functions, such as the following:

• Expressing user-interface operations

• Searched case expressions

• Conditional expressions (described in Multidimensional Expressions (OLE DB))

• Dimension write-back (covered in detail in Multidimensional Expressions (OLE DB))