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.