Chapter 12 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 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 the Generating a Database from a PDM and the Reverse Engineering a Database into a PDM chapters.
For more information on dimensions, see the Building Multidimensional Diagrams chapter.
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |