Viewing OLAP Catalog Metadata , 11 of 25

ALL_OLAP2_DIM_LEVELS

ALL_OLAP2_DIM_LEVELS lists the levels within each dimension.

Column	Data Type	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the dimension containing this level.
`DIMENSION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the dimension containing this level.
`LEVEL_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the level.
`DISPLAY_NAME`	`VARCHAR2(30)`		Display name for the level.
`DESCRIPTION`	`VARCHAR2(2000)`		Description of the level.
`LEVEL_TABLE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the dimension table that contains the columns for this level.
`LEVEL_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the dimension table that contains the columns for this level.