MDX Statements

OLE DB Programmer's Reference

<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 Chapter 25: Multidimensional Expressions)
• Dimension write-back (covered in detail in Chapter 25: Multidimensional Expressions)

1998-2001 Microsoft Corporation. All rights reserved.