ALL$OLAP2_JOIN_KEY_COLUMN_USES

Each row represents the key information that joins two levels in a hierarchy. Multiple column keys are represented by multiple rows in the view, one for each column use.

In a snowflake schema, where levels are defined in separate dimension tables, levels in a hierarchy have a logical foreign key relationship. When levels are defined within the same dimension table, the child level key specifies its position in the hierarchy.

Column	Datatype	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.
JOIN_KEY_TYPE	VARCHAR2(30)	NOT NULL	SNOWFLAKE if the join key is a logical foreign key, or STAR if the join key refers to a column within the same table.