Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)

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).

1998-2001 Microsoft Corporation. All rights reserved.