Share via


Advanced MDX

The sections described in the following table 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.