MDX Query and Slicer Axes - Restricting the Query

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/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:

• Query axes-the set of hierarchies from which data is retrieved for multiple members. For more information about query axes, see Specifying the Contents of a Query Axis (MDX).

• Slicer axis-the set of hierarchies from which data is retrieved for a single member. For more information about the slicer axis, see Specifying the Contents of a Slicer Axis (MDX).

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)