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.
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
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
The
Query Wizard - Choose Columns dialog appears.
» 
Comment and Contribute
