MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 21: OLE DB for OLAP Concepts

SalesData Example

SalesData Cube

The SalesData cube example represents the simplest cube concept and contains six dimensions. Examples throughout this guide will refer to this example.

SalesData Dataset

SalesData has the following six dimensions:

• SalesRep
  
  
• Geography, a hierarchy that has the levels Continents, Countries, States. For simplicity, only one leg of the hierarchy is shown.
  
  
• Quarters
  
  
• Years
  
  
• Measures, of which the three are Sales, PercentChange, and BudgetedSales
  
  
• Products

Consider a dataset on this cube that looks like this:

The characteristics of this dataset are as follows:

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

SalesData Dimensions/Members

SalesData Geography Hierarchies

SalesData Time Hierarchies