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