Creating a PowerOLAP Database


Create a


Creating a PowerOLAP database is the first step in developing an 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 Members; Cubes; Cube Formulas; and Slices, which display your data.

Let’s start by creating a new database, which you will name “QS Database” (short for Quick Start):

1.   Launch PowerOLAP application by going to the Start Menu then selecting Programs, PowerOLAP and then PowerOLAP.

       The PowerOLAP main application window appears:

2.   Select File icon, New Database command.
      The  New Database dialog box is displayed.

      The File Icon is the cube image located at the upper-left most corner of the PowerOLAP interface.

3.   Browse for the directory where you want to save your database (e.g., C:\Program Files (x86)\PowerOLAP\Examples).

4.   In the Save As dialog box, type the (i.e., QS Database).

5.   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 (shown in the following figure); you have the option to type in a different Database Name.

6.   Notice the Secure Database and the Allow Reserved Characters checkboxes. Leave the default settings, unchecked and checked, respectively.

The Secure Database checkbox enables you to require a password to open the database. Thus, if you check the box, then click OK, you will be prompted to give a password (and then verify it). For more information about Security, see the section in the PowerOLAP User Manual dedicated to Security features.

The Allow Reserved Characters checkbox allows you to use so-called “reserved characters”—e.g., quote, period, comma, etc.—in your database. See General Options further on in this manual for a list of these characters.

The Synchronization Server area of the dialog box refers to a PowerOLAP component that allows PowerOLAP databases to be synchronized via a shared file. The Synchronization Server area is activated if your license includes Synchronization Server capabilities (see the Synchronization Server) section; otherwise, it is grayed out. Consult your Administrator to determine whether this tool is part of your application.

7.   Click OK.          
       Note that in the PowerOLAP window, more command icons become active.

     Notice the status area, at the bottom of the interface. From left to right, the boxes indicate:

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


Only one database file (“.olp“) may be open at a time. Therefore, a new database can not be created if a database is currently open.

If you are working as a Client to an MDB Server, you cannot create a database on the Server. Typically, a new database shared by multiple clients would be created from the MDB Server Control Program. It is worth noting, though, that a user can create a database in standalone mode that can then be made available to the Server.