9.
Select the
tables listed below, from the Available Tables and Columns box on the left,
by selecting each and clicking the > button, to move the respective
columns to the right.
-
product
-
product class
-
region
-
sales_fact_1998
-
store
-
time_by_day
The Query Wizard - Choose Columns dialog appears, as
partially shown in Illustration 5.
Illustration 5: The
Query Wizard - Choose Columns Dialog (Partial View)
While
we would probably expand each table and select the specific columns we needed
for our cube, in a real-world scenario, we have selected each of the tables in
its entirety at this point, to make the process quicker for our lesson.
The Query
Wizard - Filter Data dialog appears, as shown in Illustration 6.
Illustration 6: The
Query Wizard - Filter Data Dialog
We
will simply click Next to skip this step, again noting the importance of
filtering the data in a real-world scenario, to keep cube size minimal when the
relational data source is large.
The Query
Wizard - Sort Order dialog appears, as shown in Illustration 7.
Illustration 7: The
Query Wizard - Sort Order Dialog
Again,
we will pass on sorting the data; we will not be working with the end product
in this lesson. This, too, would likely be handled differently in most
business environments.
The Query
Wizard - Finish dialog appears.
13.
Click Save
Query, and name the query LocalCubeRelational, placing it in a
convenient directory (I accepted the default).
The Save
As dialog resembles that depicted in Illustration 8.
Illustration 8: Saving
the Underlying Relational Query
We are
returned to the Query Wizard - Finish dialog.
15.
Click the Create
an OLAP Cube from this Query radio button to select it.
The Query
Wizard - Finish dialog appears, as shown in Illustration 9.
Illustration 9: The
Query Wizard - Finish Dialog
The colorful
Welcome dialog of the OLAP Cube Wizard is launched, based upon
our selection in the Finish dialog. It appears as shown in Illustration
10, awaiting instructions as to how we want it to create the cube, for
which we have established a source definition in MS Query.
Illustration 10: The
OLAP Cube Wizard Welcome Dialog Appears