Chapter 15 DBMS-Specific Features
You can design Oracle dimensions using dimensions in a PDM multidimensional diagram.
In Oracle, the columns of the dimension table are called levels of the dimension hierarchy. These levels can have dependent columns, for example, in dimension Time, 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 on dimensions, see the Building Multidimensional Diagrams chapter.
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |