Parts of an MDX Statement

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>