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>