Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

ALL_OLAP2_JOIN_KEY_COLUMN_USES

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.