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

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