Summary of Quick Start Exercises

In the preceding pages you very quickly learned important basic concepts and fundamental functions of PowerOLAP^®, including:

• Creating a PowerOLAP database, the first step in building a Cube to model multidimensional data.
• Creating Dimensions, adding Members to those Dimensions, establishing a Hierarchy among Members (whether Detail or Aggregate), and assigning an Aggregate Weight to a Child member.
• Creating a Cube from Dimensions and their respective Members.
• Creating a Slice, arranging Slice dimensions, selecting Page members to view, and changing the layout of the grid within a Slice.
• Setting general and formatting preferences from the Edit, Options Menu.
• Entering data in a Slice, and seeing how PowerOLAP automatically recalculates Aggregate members to reflect changes in value. Then, saving those changes to a database.
• Importing data from a file into a Cube.
• Creating Cube formulas.
• Creating a fully functional Excel worksheet from a Slice, and defining database reference formulas.
• Saving changes made from within Excel into the PowerOLAP modeler, and closing the PowerOLAP database, knowing that you can reopen it from a normal Excel worksheet.

Now that you have grasped the concepts and demonstrated these many functions, you are well prepared to use PowerOLAP^® product in a production environment. For more detailed instruction on using PowerOLAP^®, and to learn additional features, see the PowerOLAP^® User Manual.

A brief discussion about one of the important advanced features of PowerOLAP^®: OLAP Exchange^® component follows.