Viewing OLAP Catalog Metadata , 21 of 25

ALL_OLAP2_LEVEL_KEY_COLUMN_USES

ALL_OLAP2_LEVEL_KEY_COLUMN_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).