Viewing OLAP Catalog Metadata , 15 of 25

ALL_OLAP2_DIM_HIER_LEVEL_USES

ALL_OLAP2_DIM_HIER_LEVEL_USES shows how levels are ordered within each hierarchy.

Within separate hierarchies, the same parent level may be hierarchically related to a different child level.

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.
`PARENT_LEVEL_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the parent level.
`CHILD_LEVEL_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the child level.
`POSITION`	`NUMBER`	`NOT NULL`	Position of this parent-child relationship within the hierarchy, with position 1 being the most detailed.