| 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_LEVEL_KEY_COL_USES shows the mapping of each level to a unique key column.
If the level is mapped to more than one column, each column mapping is represented in a separate row in the view.
| 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) |
Name of the hierarchy that includes this level. | |
CHILD_LEVEL_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the level. |
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension table. |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension table. |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column that stores CHILD_LEVEL_NAME. |
POSITION |
NUMBER |
Position of the column within the key. Applies to multi-column keys only (where the level is mapped to more than one column). |
