OLAP Cube Modeling: Create a Cube

How To Create a Cube Using the PowerOLAP Cube Modeler

Using Excel as a Front End Video

Using Excel as a Front Instructions

Using the Dimensions created in the previous exercises you will now create a PowerOLAP Cube that will store and model your data.

To create a Current Year Budget cube:

1. From the Main application window, select Model > Cubes. The Cubes dialog box is displayed:
PowerOLAP Creating a Cube


2. Type Current Year Budget in the Cubes dialog box. Click “Add”. The Define Cube dialog box appears, in which you select Dimensions to be used by the Cube:
PowerOLAP Creating a Cube


3. Select all of the Dimensions in the Available Dimensions list box by clicking the PowerOLAP Creating a Cube button. All three Dimensions are moved to the Selected Dimensions list box on the right.

4. Click “OK”. Note that the Current Year Budget cube is now listed in the Cubes dialog box.
PowerOLAP Creating a Cube
All of the Cubes dialog’s buttons on the right are activated. These buttons control functionality associated with Formulas and setting Security privileges, as well as the OLAP Exchange capability to push data ranges back to a relational database—they are covered in depth in the PowerOLAP User Manual and OLAP Exchange manual respectively.

5. Click “OK” to return to the Main application window.

The Current Year Budget cube is now ready for data input

Next Tutorial:   Cube Formulas  >>