Chapter 14 DBMS-Specific Features
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 using ODBC.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |