Axis and Slicer Dimensions

When formulating an MDX query, an application typically looks at the cubes and divides the set of dimensions into two subsets:

• Axis dimensions, for which data is retrieved for multiple members
• Slicer dimensions, for which data is retrieved for a single member

For example, suppose there are four dimensions: Geography, Products, Measures, and Quarters. There are two measures: Sales and Cost. You want to see Sales for USA for each product category and each quarter. The output looks like the following table:

In this example, the Quarters and Products dimensions are the axis dimensions. Measures and Geography are the slicer dimensions.