Because we are focusing
on concepts and general procedures in this lesson, we will stop at the Month
level, even though, had our source date fields consisted of data that was truly
of a datetime type, we might have proceeded to build our model to support
analysis at the hour, or even lower, levels. This is not an uncommon
requirement with web statistics analysis, in my experience, and Analysis
Services is certainly up to the task, assuming that the appropriate level of
granularity exists in the source data.
At this juncture, the cube
tree should appear as shown in Illustration 26.
Illustration 26: Cube
Tree, Reflecting Our Modifications, and Additions of Levels, Thus Far
Now let's focus on the IPAdd
dimension, which, in this simple model, will store IP Address information for
the visitors to our web site.
Select the IPAdd
dimension in the Dimensions folder.
Click the Basic tab in
the Properties pane, as required.
Rename the dimension to Source.
Type the following into the Description
Visitor IP Address
The Basic tab of
the Properties pane for the Source dimension appears as shown in Illustration
27: Source Dimension, Properties Pane, Basic Tab
Click the Advanced tab
in the Properties pane.
Type the following into the All
The Advanced tab
of the Properties pane for the Source dimension appears as
depicted in Illustration 28.
Illustration 28: Source
Dimension, Properties Pane, Advanced Tab
Expand the Source
dimension to expose the IPAdd level underneath.
Click the IPAdd level to
select it in the cube tree.
Ensure the Basic tab in
the Properties pane is selected.
Rename the level to IP
Press Enter to apply the
The cube tree should
now appear as depicted in Illustration 29.
Illustration 29: Cube
Tree, Reflecting All Modifications and Additions
Let's make one more
enhancement to our cube before saving and processing it. We will enable
drillthrough to allow us to "explode" on a specific value within our
browses to see the underlying detail at the source table level.
Select Tools ->
Drillthrough Options ... from the
Drillthrough Options dialog appears.
Click the Enable
Drillthrough check box (in the upper left corner of the dialog) to check
Click the "Date" and
"IPAdd" check boxes to check them.
The Cube Drillthrough Options dialog appears as shown in Illustration
Illustration 30: The
Save the Cube Dialog
The Drillthrough Settings warning message box appears, as
seen in Illustration 31.
Illustration 31: The
Save the Cube Dialog
We will process the cube at this stage.