Open a PowerOLAP® Database

Open Database

The Open Database command, a sub-command under the File command, allows you to open an existing database file.



Only one PowerOLAP database may be opened at a time.

If you have a version of PowerOLAP® that is not Server-enabled, the Server text box at the top of the dialog box will be grayed out. Consult the PowerOLAP® MDB Server section for further information about connecting to a Server.


For this example, you will be working locally and not from a Server, so there is no need to choose from the Server drop-down in any case



To open an existing database:

1.   Select File button, Open Database command. The Open Database dialog box appears.


Note: When the File button is selected, the Recent Documents section on the right-hand side of the dialog box that shows up lists the recently opened PowerOLAP database file names.

2.   Click the Browse button next to the File Name text field in the Open Database dialog box.

3.   Select the database file to be opened, (in this case, UsingPO), by browsing to locate it, e.g., C:\Program Files (x86)\PowerOLAP\Examples\.

4.   Click Open in the Open dialog box.


Notice the Open Database in Safe Mode checkbox at the bottom of the Open Database dialog box. The purpose of safe mode is to resolve problems caused by inefficient or poorly written dependencies. In the event that dependencies were inefficiently written this could result in the inability to open the database due to excessive memory usage. Safe mode allows a user to open the database without compiling the dependencies, resolve the problem, and then open the database normally.
The Logon as Administrator checkbox on the other hand is used to login as an administrator to a secured PowerOLAP database where the Windows Authentication feature in PowerOLAP has been enabled. This way, instead of automatically logging the user in the secured database as the windows user, PowerOLAP will prompt for a user and password authentication.

5.  For this example leave the Open Database in Safe Mode and Logon as Administrator checkboxes disabled.

6.  Click OK in the Open Database dialog box.

The selected database is opened, and the status bar in the main application window become active. At the same time, by going through the different ribbon tabs notice that more commands become active as well.