Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 25, 2003

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

By William Pearson

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM