Table of Contents
Using the Power*Architect OLAP Schema Editor you can also create a multidimensional data model that includes dimensions, cubes and measures.
The development of the OLAP Schema Editor is still in an early stage so not all it's functionality is implemented yet. We welcome you to try it out and give us your feedback. This part of the manual covers only a small part of the functionality and is intended for users with experiences in building Mondrian OLAP schemas.
To create an OLAP schema select OLAP->Edit Schema->New Schema. Select the database your schema will be based on and enter a name for the new schema. The list of database connections corresponds to the databases available in the DB Tree in the main Architect frame. If you'd like to base your OLAP schema on an existing database, simply connect to that database in the DB Tree before creating your OLAP schema. Now you can easily add cubes, measures and dimensions to your schema by clicking on the according icon on the right side.
For more details on multidimensional schemas, please read the Mondrian schema specifications.
To import an OLAP schema select OLAP->Import Schema. After selecting the schema file you can enter the name of the schema and select the related database.
You can export OLAP schemes to PDF and XML with right-clicking on the Playpen in the OLAP Schema Editor. To export it to XML select 'Export Schema...', to export it to PDF select 'Export Playpen to PDF'.