In Power*Architect all dimensions are modeled as shared dimensions. Degenerate dimensions are not supported.
To add a shared dimension:
Click on
to create a new dimension.The cursor will change to a crosshair. Move the cursor near the left of the Playpen area, and click.
The dimension properties dialog box appears.
Enter the following information:
In this field ...
Do this ...
Name
Enter the dimension name.
Caption
Enter the dimension caption.
Type
Select if your dimension is a standard dimension or a time related dimension.
To add a dimension usage:
Click on
to create a new dimension usageThe cursor will change to a crosshair. Do a left click on the cube you want to use the dimension in.
Do a left click on the dimension you want to use.
The dimension usage property box appears.
Enter the following information:
In this field ...
Do this ...
Caption
Enter the dimension usage caption.
Foreign Key
Select the related foreign key.
To add a hierarchy:
Right click on the dimension you want to add the hierarchy to.
Select "New hierarchy".
The hierarchy properties dialog box appears.
Enter the following information:
In this field ...
Do this ...
Name
Enter the hierarchy name.
Caption
Enter the hierarchy caption.
Has All
Select if Hierarchy has an all level element.
All Level Name
Enter the name of the all level element.
Table
Select the table the hierarchy belongs to.
Primary Key
Select the related primary key.
To add a level
Right click on the hierarchy you want to add a level to.
The level properties dialog box appears.
Enter the following information:
In this field ...
Do this ...
Name
Enter the level name.
Caption
Enter the level caption.
Column
Select the column your level is based on
Unique members
Select if the level has unique members.
Level Type
Enter the type of the level. This selection is only available if you set the dimension type to a time dimension.
Properties
Add properties to the level.