View source

__NOTOC__

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 [[Members]]; [[Cubes]]; [[Cube Formulas]]; and [[Slices]], which display your data.

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


[[Image:Examples_QS_Database.jpg|Quick Start PowerOLAP Database]]


::2. Select "File > New Database", or click on the "New Database" button on the toolbar. The following New Database dialog box is displayed.


[[Image:Examples_QS_Database2.jpg|Quick Start PowerOLAP Database]]


::3. Click '''"Browse"''' in the Database Name text box.

::4. In the '''"Save As"''' dialog, type '''"QS Database"''' (short for Quick Start).

::5. Follow the directory path: '''C:\Program Files\PowerOLAP\Examples\'''


[[Image:Examples_QS_Database3.jpg|Quick Start PowerOLAP Database]]


::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'''.


[[Image:Examples_QS_Database4.jpg|Quick Start PowerOLAP Database]]

::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

[[Image:Examples_QS_Database5.gif|frame|none|]]

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

====Now try [[Example 2|Example 2 - OLAP Dimensions and Members]]====

----
* [[Example 3|Example 3 - Hierarchies and Aggregate Weights]]
* [[Example 4|Example 4 - OLAP Cubes and Slices]]
* [[Example 5|Example 5 - OLAP Cube Formulas]]
* [[Example 6|Example 6 - OLAP and Excel]]


[[Category:Download and Learn]]