| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_OLAP2_DIM_HIER_LEVEL_USES shows how levels are ordered within each hierarchy.
Within separate hierarchies, the same parent level may be hierarchically related to a different child level.
| Column | Data Type | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension. |
HIERARCHY_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the hierarchy. |
PARENT_LEVEL_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the parent level. |
CHILD_LEVEL_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the child level. |
POSITION |
NUMBER |
NOT NULL |
Position of this parent-child relationship within the hierarchy, with position 1 being the most detailed. |
