Let's process our new
cube, and then take a look at the results via the Cube Browser.
Select Tools ->
Process Cube from the main menu.
The Save the Cube dialog appears as shown in Illustration
The Cube: New Name dialog
Name the cube Web Site
Traffic, as shown in Illustration 33.
Illustration 33: The Cube:
New Name Dialog
A message box (shown in
Illustration 34) appears warning that the cube has no aggregations
designed, and asking if we want to design aggregations prior to processing the
Illustration 34: Warning
Message Box: No Aggregates Designed
The Process a Cube
dialog appears, as depicted in Illustration 35. The Full Process
option is selected by default, as this is the first time the cube has been
proposed for processing.
Illustration 35: The
Process a Cube Dialog
Cube processing begins,
as evidenced in the status display of the Process dialog that appears.
Processing rapidly completes, at which point the Process dialog appears similar
to that partially shown in Illustration 36, displaying a "Processing
Completed Successfully" statement in green at the bottom of the dialog.
Illustration 36: The
Process Dialog, Displaying Status (Partial View)
Click File -->
Exit from the top menu to close
the Cube Editor.
The Cube Editor
closes, and we are returned to the Analysis Manager console.
Expand the Cubes folder
within which we have been working.
We see the Web Site
Traffic Cube in the tree pane, as depicted in Illustration 37.
Illustration 37: The Analysis
Manager Console - Tree Pane (Partial View)
Keep in mind
that we must process the cube before browsing actual data, anytime we build a
new cube and design its storage options and aggregations, or anytime we change
a cube's structure (measures, dimensions, and so on), where we intend to save
the changes to the cube. We must also process a cube anytime we change the
structure of a shared dimension (via the Dimension Wizard) used in the
cube. If data in the data source (i.e. data warehouse) supporting the cube has
been added or changed, processing is appropriate to furnish updated, accurate
results when browsing the cube.
Let's take a
look at the data in our cube at this point, to get a feel for the effectiveness
of our design.