| 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_JOIN_KEY_COLUMN_USES shows the joins between two levels in a hierarchy. The joins are between dimension tables in a snowflake schema, and between level columns in a star schema.
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) |
NOT NULL |
Name of the hierarchy. |
CHILD_LEVEL_NAME |
VARCHAR2(30) |
NOT NULL |
Child level in the hierarchy. |
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 child level column in the dimension table. In a star schema, this is the column associated with CHILD_LEVEL_NAME. In a snowflake schema, this is the parent column of CHILD_LEVEL_NAME in the same dimension table. |
POSITION |
NUMBER |
Position of column within the key. Applies to multi-column keys only (where the level is mapped to more than one column). | |
JOIN_KEY_TYPE |
VARCHAR2(30) |
NOT NULL |
The key is of type SNOWFLAKE if the join key is a logical foreign key. The key is of type STAR if the join key refers to a column within the same table. |
