MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 24: Multidimensional Expressions
The following sections explain MDX statements in detail.
| Topic | Description |
| The MDX Statement | Contains a complete description of the construct. |
| Retrieving Member Properties and Retrieving Cell Properties | Dimension members and cells both have associated properties. These sections explain how to retrieve those properties. |
| Join Compatibility | Explains compatibility issues when joining cubes and presents JOIN examples. |
| Empty FROM Clause | Explains provider support of implicitly deriving the cube from the specified axis and slicer dimensions. |
| Default Hierarchy and Member | Describes the default hierarchy and default member for dimensions. |
| Types of Expressions in MDX | Set, Member, Tuple, Number, and Time expressions are discussed in detail. |
| Comparing CROSSJOIN and ORDER: A Provider Implementation Note | Explains the differences both in use and in results between the CROSSJOIN and ORDER functions. |
| WHERE Clause Overrides | Explains special cases when using the WHERE clause. |
| Creating a Cell Within the Context of a Cube | Describes returning data for a single cell. |
| Querying on Property Values | Explains how to retrieve property values. |
| Using Outer References in a Query | Describes outer references. |
| Named Sets and Calculated Members | Describes how to specify a name for set expressions and formulas. |
| Set Functions for Expressing User-Interface Operations | Describes drilling operations on schema rowsets that are commonly exposed in a user interface. |
| Preserving State During User-Interface Operations | Describes state preservation during drilling operations on schema rowsets that are commonly exposed in a user interface. |
| Conditional Expressions | Explains the following conditional expressions: |
| Empty Cells | Explains working with empty cells. |