Introduction to MSSQL Server 2000 Analysis Services: Another Approach to Local Cube Design and Creation - Page 3

June 21, 2004

Starting with the Relational Data Source

Let's get started with defining the rowset upon which the cube will be based. We will keep the structure fairly simple to allow us to focus on design and creation concepts as we proceed.

1.  Open a new Microsoft Excel ("Excel") worksheet.

2.  Select Data from the top menu.

3.  Select Import External Data from the dropdown menu.

4.  Click New Database Query from the cascading menu, as shown in Illustration 1.

Click for larger image

Illustration 1: Initializing the Database (Rowset) Query

MS Query is initialized, and the Choose Data Source dialog appears.

5.  On the Database tab of the dialog (the default when the dialog appears), choose Microsoft Access Database.

We leave the Query Wizard enabled, via the default setting on the dialog - the checkbox - to assist in guiding us through the design process.

The Choose Data Source dialog appears, with our selection, as depicted in Illustration 2.

Illustration 2: The Choose Data Source Dialog for Microsoft Query

6.  Click OK.

The Select Database dialog appears, along with a Connecting to Data Source progress dialog, as shown in Illustration 3.

Illustration 3: The Select Database Dialog

7.  Find and select the FoodMart 2000 Access database (FoodMart 2000.mdb), which is typically installed in the Samples folder of the Microsoft Analysis Services directory under Program Files on the drive upon which the Typical installation took place (in my case, for example, the .mdb is located at D:\Program Files\Microsoft Analysis Services\Samples).

The Select Database dialog, with our selection, appears as that depicted in Illustration 4:

Illustration 4: The Select Database Dialog

8.  Click OK.

The Query Wizard - Choose Columns dialog appears.