Sample Cube

The examples below assume a cube called SalesCube with the following structure:

• The cube has four dimensions: Geography, Measures, Time, Products.
  
  
• Geography dimension has:
  • 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 and Quebec)
    
    
  • Level 3: City (Kansas has Topeka, Wichita. New York has Buffalo, Ithaca. BC has Vancouver, Victoria. Quebec has Montreal, Sherbrooke)
    
    
  • Level 4: Zipcode
• Time has:
  • Level 0: All; one member, also All.
    
    
  • Level 1: Year. Members are the usual suspects.
    
    
  • Level 2: Month. Members are the usual suspects
    
    
  • Level 3: Day. Members are the usual suspects
• 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 Word belonging to the Products level (at level 2).