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

October 7, 2002


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









The Network for Technology Professionals

Search:

About Internet.com

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