ALL_OLAP2_DIM_LEVELS

ALL_OLAP2_DIM_LEVELS is a synonym for ALL$OLAP2UDIM_LEVELS.

Each row represents a level within a dimension. A level is mapped to one or more columns within a dimension table. In a star schema, all of a dimension's levels are mapped to columns within the same table. In a snowflake schema, a dimension's levels are mapped to columns in separate tables.

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.