Viewing OLAP Catalog Metadata , 22 of 25

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.