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

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

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 7, 2002

Introduction to SQL Server 2000 Analysis Services: Parent-Child Dimensions - Page 10

By William Pearson

We see that we have attained our objective with the small sample above. Note that Ms. Nowmer's individual information is reflected (Sheri Nowmer-Individual) as well as the total for her area of responsibility (Sheri Nowmer-Total).

We will now process the cube (having modeled our work so far with sample data, as noted in the warnings that appeared at the bottom of the Data Preview pane.

25. Right-click MyCube2 in the cube tree of the Cube Editor.
26. Click Process Cube on the context menu, as shown in Illustration 35.

Illustration 35: Select Process Cube...

Cube processing can also be kicked off from the Main Menu (Tools) or from the Process Cube button in the toolbar.

We receive a warning to save the cube (dialog shown below), unless we have saved it as recently as the last modification.

Illustration 36: Select Yes to Save the Cube

27. Click Yes to approve the save.

We next receive a dialog regarding aggregation matters, asking if we wish to start the Storage Design Wizard, as shown below.

Illustration 37: "Just Say No" to Storage Design Wizardry

28. Click No.

The Process a Cube: Select the Processing Method dialog appears, as depicted in Illustration 38.

Illustration 38: The Process a Cube: Select the Processing Method Dialog

29. Click the Full Process radio button to select it, if necessary.

The Process status dialog appears, displaying status until processing completion, with a final display similar to that in Illustration 39.

Illustration 39: The Process Status Dialog upon Successful Completion

30. Click Close to close the Process status dialog, and to refresh the Data Preview pane.

The Process status dialog disappears, leaving behind a refreshed Preview pane similar to that shown below.

Illustration 40: The Preview Pane after Processing MyCube2

We have thus built in the capability of the parent levels to display the data associated with them, and so provided a "rollup" context.

Page 11: Next in Our Series

See All Articles by Columnist William E. Pearson, III

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