MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements

Sample Cube

The cube examples in this chapter assume a cube called SalesCube with the following structure:

• The cube has four dimensions: Geography, Measures, Time, Products.
  
  
• The Geography dimension has these levels and members:
  • Level 0: [All] (One member, also called [All])
    
    
  • Level 1: Country (Two members: USA, Canada)
    
    
  • Level 2: State (USA has two states: Kansas, New York. Canada has two states: BC, Quebec)
    
    
  • Level 3: City (Kansas has Topeka, Wichita; New York has Buffalo, Ithaca; BC has Vancouver, Victoria; Quebec has Montreal, Sherbrooke)
    
    
  • Level 4: ZIP code
• The Time dimension has these levels and members:
  • Level 0: [All] (One member, also [All])
    
    
  • Level 1: Year
    
    
  • Level 2: Month
    
    
  • Level 3: Day
• There are two measures: Sales and Cost.
  
  
• There are many product levels with many members, but for this example, assume "Office" as a member belonging to the "ProductLine" level (at level 1), and Microsoft® Access and Microsoft Word belonging to the Products level (at level 2).