Advanced MDX

Article
07/05/2016

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: IF Clause Simple Case Expression Searched Case Expression
Empty Cells	Explains working with empty cells.