Parts of an MDX Statement

OLE DB Programmer's Reference

To specify a dataset, the MDX statement must contain information about the following:

• The cube or cubes that set the scope of the query.
• The number of axes.
• The dimensions projected on each axis and the level of nesting at which each dimension appears on the axis.
• The members or member tuples to include from each dimension, and the sort order.
• The members from a nonprojected dimension on which the data will be filtered for members from projected dimensions.

A typical MDX statement takes the following form:

SELECT <axis_specification> [, <axis_specification>...] FROM <cube_specification> WHERE <slicer_specification>

1998-2001 Microsoft Corporation. All rights reserved.