Cube and Dataset Example

In this example — which will be repeatedly referenced in the rest of this document — SalesCube has the following six dimensions:

• SalesPerson
  
  
• Geography, a hierarchy that has the levels Continents, Countries, States, and so on
  
  
• Quarters, a hierarchy that has the levels Quarters, Months, Days
  
  
• Years
  
  
• Measures, of which the three measures are Sales, PercentChange, and BudgetedSales
  
  
• Products

Consider a dataset on this cube that looks like this:

The characteristics of this dataset are:

• Axis dimensions: Quarters, SalesPerson, Geography
  
  
• Slicer dimensions: Measures, Years, Products
  
  
• Two axes: COLUMN, x-axis, or axis 0; and ROW, y-axis, or axis 1
  
  
• x-axis: Salesperson and Geography dimensions (the latter is nested in the former)
  
  
• y-axis: Quarters dimension