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.