Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I) - Page 10
January 6, 2003
Cube processing begins, as evidenced in the status display of the Process dialog shown below:
Click for larger image
The Process 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.
8. Click Close.
9. Click the Data tab.
After a "Retrieving Data" message briefly appears, we see the actual data presented in the Preview pane, as shown below.
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.
We must 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.
10. Select File --> Exit to leave the Cube Editor for now, and to return to the Analysis Manager console.