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.
The Query Wizard - Choose Columns dialog appears, as
partially shown in Illustration 5.
Illustration 5: The
Query Wizard - Choose Columns Dialog (Partial View)
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.
Wizard - Filter Data dialog appears, as shown in Illustration 6.
Illustration 6: The
Query Wizard - Filter Data Dialog
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.
Wizard - Sort Order dialog appears, as shown in Illustration 7.
Illustration 7: The
Query Wizard - Sort Order Dialog
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
Wizard - Finish dialog appears.
Query, and name the query LocalCubeRelational, placing it in a
convenient directory (I accepted the default).
As dialog resembles that depicted in Illustration 8.
Illustration 8: Saving
the Underlying Relational Query
returned to the Query Wizard - Finish dialog.
Click the Create
an OLAP Cube from this Query radio button to select it.
Wizard - Finish dialog appears, as shown in Illustration 9.
Illustration 9: The
Query Wizard - Finish Dialog
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