MDX Query and Slicer Axes - Restricting the Query

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hierarchies into two subsets:

Because query and slicer axes can be constructed from multiple hierarchies of the cube to be queried, these terms are used to differentiate the hierarchies used by the cube that is to be queried from the hierarchies created in the cube returned by an MDX query.

To see a simple example using query and slicer axes, see Using Query and Slicer Axes in a Simple Example (MDX).

See Also

Working with Members, Tuples, and Sets (MDX)
MDX Query Fundamentals (Analysis Services)