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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 11, 2002

Introduction to SQL Server 2000 Analysis Services: Working with the Cube Editor - Page 7

By William Pearson


Processing the Cube

Let's process our new cube, and then take a look at the results via the Preview pane on the Data tab.

1.      Select Tools from the main menu.

2.      Click Process Cube, as shown below.



Illustration 21: Select Tools -> Process Cube


NOTE: We might have alternatively chosen the Process Cube button depicted in Illustration 22. We might also have right-clicked the cube, and selected Process Cube from the context menu.



Illustration 22: Process Cube Button


The Save the Cube dialog appears as shown below.



Illustration 23: The Save the Cube Dialog


The Cube: New Name dialog appears.

3.      Name the cube ANSYS05, as shown in Illustration 24.



Illustration 24: The Cube: New Name Dialog


4.      Click OK.

A message box (shown below) appears, warning that the cube has no aggregates designed, and asking if we want to design aggregations prior to processing the cube.



Illustration 25: Warning Message Box: No Aggregates Designed


5.      Click No.

The Process a Cube dialog appears, as shown in Illustration 26. The Full Process option is selected by default, as this is the first time the cube has been proposed for processing.



Illustration 26: The Process a Cube Dialog


6.      Click OK.

Cube processing begins, as evidenced in the status display of the Process dialog shown below:



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.

7.      Click Close.

8.      Click the Data tab.

We see the actual data presented in the Preview pane, as shown below.



Illustration 28: Partial View, Actual Data in the Preview Pane (Compressed)


Note that our dimensions, Calendar.Time, Customer and Product, 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 so as to limit the initial cube build to a central fact table.

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) and save the changes to the cube. We must also process a cube anytime 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.


Page 8: Expanding the Basic Cube with the The Cube Editor


See All Articles by Columnist William E. Pearson, III




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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