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

Illustration 27: The Process Dialog, Displaying Status

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.


Illustration 28: 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.

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.

Page 11: Enhancing the Basic Cube with The Cube Editor








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers