Introduction to MSSQL Server 2000 Analysis Services: Build a Web Site Traffic Analysis Cube: Part II - Page 8

August 25, 2003

Processing the Cube

Let's process our new cube, and then take a look at the results via the Cube Browser.

1. Select Tools -> Process Cube from the main menu.

The Save the Cube dialog appears as shown in Illustration 32.

Click for larger image

Illustration 32: The Save the Cube Dialog

2. Click Yes.

The Cube: New Name dialog appears.

3. Name the cube Web Site Traffic, as shown in Illustration 33.


Illustration 33: The Cube: New Name Dialog

4. Click OK.

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 cube.


Illustration 34: Warning Message Box: No Aggregates Designed

5. Click No.

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

6. Click OK.

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)

7. Click Close.

8. 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.

9. 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.








The Network for Technology Professionals

Search:

About Internet.com

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