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)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om