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.