Effective MDX

Analysis Services

Analysis Services

Effective MDX

This topic provides information on more effective uses of Multidimensional Expressions (MDX) functions in various scenarios. The topics covered are listed in the following table.

Topic Description
Comments in MDX Describes the use of comments in MDX statements.
Working with Empty Cells Explains the behavior and functions associated with empty cells in MDX.
Creating a Cell Within the Context of a Cube Covers the creation of an MDX query that returns a single cell.
Working with the RollupChildren Function Discusses the impact of the RollupChildren function on analysis of multidimensional data.
WHERE Clause Overrides Details how and when the WHERE clause of an MDX query can override the resolution of individual set, member, tuple, or numeric functions in an MDX statement.