Model Cubes
![]()
Cubes Toolbar Button |
The Cubes command, found on the Model menu, allows you to create, rename and delete Cubes in a currently open database. |
Create a Cube as follows:
1. In the PowerOLAP ribbon, go to Model tab then in the Model control group select the Cubes command.
The Cubes dialog box is displayed.
2. Enter <new Cube name> in the Cube text box.
We will create a Cube called ByRegion, so type that into the text box.
3. Click the Add button.
The Define Cube dialog box appears. This is where you will select Dimensions to be used within the new Cube.
Moves Dimension(s) selected in the Available Dimensions list box to the Selected Dimensions list box.
Moves all available Dimensions from the Available Dimensions list box to the Selected Dimensions list box.
Moves Dimension(s) selected in the Selected Dimensions list box to the Available Dimensions list box.
Moves all Dimensions from the Selected Dimensions list box to the Available Dimensions list box.
The procedure for constructing a Cube from Selected Dimensions is as follows:
4. Select the Dimensions you want to use in the Cube.
(You can demonstrate this by selecting the Dimensions that appear in the Selected Dimension list box in the figure below.)
Use Shift or Ctrl to select more than one Dimension.
5. Click the appropriate button. The selected Dimensions are moved to the Selected Dimensions list box.
6. To make a Cube accept only numeric data, tick the Numeric Data Only check box at the bottom of the dialog box.
7. Click OK when complete.
You are returned to the Cubes dialog box.
At this time, you can create, delete or rename (other) Cubes; define Cube Formulas (Cube Formulas will be explained in another section, refer to Formulas section of this manual); or set other features of the Cube such as Fact Data security (discussed in section on Applying Database Security).
Rename Cube
PowerOLAP Cubes can be renamed without losing or deleting Meta Data or Fact Data.
Important
If you have defined Cube Formulas, you must replace the old Cube name, wherever it appears, with the new Cube name in those Formulas.
Change the name of a Cube as follows:
1. In the PowerOLAP ribbon, select Model tab then Cubes command.
2. Select the Cube to rename.
3. Enter <new Cube name> in the Cube text box.
4. Click the Rename button.
5. Click OK to close the Cubes dialog box.
Delete Cube
The Cubes dialog box also gives you the ability to delete a Cube.
Warning
Deleting a Cube will result in the loss of all data contained within the Cube. Use caution when deleting Cubes.
Delete a Cube as follows:
1. In the PowerOLAP ribbon, select Model tab then Cubes command.
2. Select the Cube to be deleted.
3. Click the Delete button.
4. Click OK to close the Cubes dialog box.
Save Cube Changes to Disk
![]()
Save Database |
The Save Database command found on the File menu allows you to save any changes that have been made within an open database—including Cubes you have created, or changes made to a Cube. All characteristics of a Cube will be saved to disk, including Dimension, Hierarchy, Member, Cube Formulas (see Formulas Section) and Fact Data entries. (Note that the Save Database command will not save unnamed open Slices—see Save a PowerOLAP Database, in the previous section, for an explanation of the Save Database and Save As commands.). |
Save a new Cube or changes to a Cube within a database as follows:
1. In the PowerOLAP ribbon, select File button then Save Database command.