LISTING 1: Using an ADO MD Connection String to Create a Local Cube

LOCATION=C:\Sales.cub;
SOURCE_DSN=" Provider=MSOLAP; data source=localhost; INITIAL CATALOG=FoodMart 
2000";
CREATECUBE=Create CUBE [Sales](
   DIMENSION [Customers],
      LEVEL [All Customers] TYPE ALL,
      LEVEL [Country],
      LEVEL [State Province],
      LEVEL [City],
      LEVEL [Name],
   DIMENSION [Product],
      LEVEL [All Product] TYPE ALL,
      LEVEL [Product Family],
      LEVEL [Product Department],
      LEVEL [Product Category],
      LEVEL [Product Subcategory],
      LEVEL [Brand Name],
      LEVEL [Product Name],
   DIMENSION [Time] TYPE TIME,
      LEVEL [Year] TYPE YEAR,
      LEVEL [Quarter] TYPE QUARTER,
      LEVEL [Month] TYPE MONTH,
   MEASURE [Unit Sales] FUNCTION SUM);

INSERTINTO=INSERT INTO [Sales](
    [Customers].[Country],
    [Customers].[State Province],
    [Customers].[City],
    [Customers].[Name],
    [Product].[Product Family],
    [Product].[Product Department],
    [Product].[Product Category],
    [Product].[Product Subcategory],
    [Product].[Brand Name],
    [Product].[Product Name],
    [Time].[Year],
    [Time].[Quarter],
    [Time].[Month],
    Measures.[Unit Sales])
SELECT
    [Sales].[Customers:Country],
    [Sales].[Customers:State Province],
    [Sales].[Customers:City],
    [Sales].[Customers:Name],
    [Sales].[Product:Product Family],
    [Sales].[Product:Product Department],
    [Sales].[Product:Product Category],
    [Sales].[Product:Product Subcategory],
    [Sales].[Product:Brand Name],
    [Sales].[Product:Product Name],
    [Sales].[Time:Year],
    [Sales].[Time:Quarter],
    [Sales].[Time:Month],
    [Sales].[measures:Unit Sales]
FROM [Sales];