In Oracle, the columns of the dimension table are called levels of the dimension hierarchy. These levels can have dependent columns. For example, in the dimension Time, the level Quarter has a dependent column called Number of business days.
The following mapping is established between dimensions in Oracle and PowerDesigner:
|
Oracle object |
PowerDesigner object |
|---|---|
|
Dimension |
Dimension |
|
Hierarchy |
Dimension hierarchy |
|
Level |
Dimension attribute used in a hierarchy |
|
Attribute |
Dimension attribute used as detail attribute |
Oracle dimension creation and deletion orders can be generated and reverse engineered in PowerDesigner. Both generation and reverse engineering can be done by script or through a live database connection. For more information, see Generating a Database from a PDM and Reverse Engineering a Database into a PDM.
For more information on dimensions, see Dimensions (PDM).