Cube processing begins, as evidenced in the status display of the Process
dialog shown below:
dialog displays status events within the cube processing evolution, and then
displays a "Processing Completed Successfully" statement in green at the bottom
of the dialog when processing is finished.
Click the Data tab.
After a "Retrieving
Data" message briefly appears, we see the actual data presented in the Preview
pane, as shown below.
Actual Data in the Preview Pane (Compressed View)
If we switch out the Calendar.Time
dimension with the others appearing in the upper pane of the data tab, we see
that the dimensions, Calendar.Time and Store, are represented by
numbers, (the ID fields in the fact table), within the various views we can
access. This is expected, as we have used only the ID keys to create the
dimensions, much as we have in past lessons, to limit the initial cube build to
a central fact table.
process the cube before browsing actual data, whenever we build a new cube and
design its storage options and aggregations, or when we change a cube's
structure (measures, dimensions, and so on), where we save the changes to the
cube. We must also process a cube whenever we change the structure of a shared
dimension (using 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.
Select File --> Exit to
leave the Cube Editor for now, and to return to the Analysis Manager console.