How To Create an OLAP Database


Creating an OLAP Database Instructions

Creating a PowerOLAP database is the first step in developing an OLAP application to store and model your data. The PowerOLAP database file, which has an “.olp” file extension, will contain all the components of your model. As you will see, these components include Dimensions and their MembersCubesCube Formulas; and Slices, which display your data.

1. From the Start Menu, select Start > Programs > PowerOLAP. The PowerOLAP main application window appears.

powerolap-main-application-window

2. Select the orange cube on the top left > “New Database”, or click on the “New Database” button on the toolbar.

powerlap-new-database

The following New Database dialog box is displayed:

powerolap-save-database-2

3. Click “Browse” in the Database Name text box.
4. In the “Save As” dialog, type “QS Database” (short for Quick Start).
5. Choose a directory path for saving: C:\Desktop\PowerOLAP\

powerolap-save-database-3

6. Click “Save”. The New Database dialog box returns, displaying the Database Name as well as the path and file name of the database file.

In this case the Database Name will be the same as the File Name.

powerolap-save-database-2

7. Click “OK”Note that in the PowerOLAP window, all eight menu items appear, and that several more toolbar buttons are now active. Notice the status area, circled in the figure. From left to right, the boxes indicate:

** Whether you are working in Local or Server mode (Server name will be indicated)
** The Database Name
** Synchronization Server Name, if active

powerolap-open-database-status

 

Note: Only one database file (“.olp”) may be open at a time.