Process the Cube from the Cube Editor
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 Preview pane, and as we discussed
in the cube tree of the Cube Editor.
Click Process Cube on
the context menu, as shown in Illustration 60.
Illustration 60: Select Process Cube...
We receive a warning to
save the cube, as shown below, unless we have saved it more recently than the
Illustration 61: Select Yes to Save the Cube
Click Yes to perform the
We next receive a
dialog regarding aggregation matters, asking if we wish to start the Storage
Design Wizard, as shown below.
Illustration 62: "Just Say No" to Storage Design Wizardry
The Process a Cube:
Select the Processing Method dialog appears, as depicted in Illustration
Illustration 63: The Process a Cube: Select the Processing Method Dialog
Click the Full Process
radio button to select it, if necessary.
Process status dialog appears, displaying status until completion, with
a final display similar to that partially shown in Illustration 64.
Illustration 64: Partial View of the Process Status Dialog upon Successful Completion
Click Close to close the
Process status dialog
Process status dialog disappears.
Click the Data tab to
refresh the Preview pane.
Expand All Calendar.Time,
then Calendar Year 1997 to obtain a view similar to that shown below.
Illustration 65: The Preview Pane after Processing ANSYS05
Explore with drilldown and
browse as desired, then close Analysis Services.
For more information on
browsing the cube, see Article 1 of this series, Creating Our First Cube.
We have added the
requested measures to our cube, using a derived measure and a calculated
measure, so as to gain exposure to each. Our cube stands ready for browsing and
reporting with the dimensions and measures in place as required.
Page 15: Next in Our Series...
See All Articles by Columnist William E. Pearson, III