Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Effective MDX

Effective MDX

SQL Server 2000

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.

© 2015 Microsoft