Viewing OLAP Catalog Metadata , 20 of 25

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS shows the mapping of each level attribute to a column.

The mapping of level attributes to levels is dependent on hierarchy. The same level may have different attributes when it is used in different hierarchies.

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 containing this level.
`ATTRIBUTE_NAME`	`VARCHAR2(30)`		Name of a dimension attribute grouping containing this level attribute.
`LVL_ATTRIBUTE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the level attribute, or name of the column if the level attribute name is not specified.
`LEVEL_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the level.
`TABLE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the dimension table containing the level and level attribute.
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the dimension table containing the level and level attribute columns.
`COLUMN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the column containing the level attribute.
`DTYPE`	`VARCHAR2(10)`	`NOT NULL`	Data type of the column containing the level attribute.