2.136 ALL_CUBE_DIM_LEVELS

ALL_CUBE_DIM_LEVELS describes the OLAP dimension levels accessible to the current user.

Related Views

• DBA_CUBE_DIM_LEVELS describes all OLAP dimension levels in the database.

• USER_CUBE_DIM_LEVELS describes the OLAP dimension levels owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(128)	NOT NULL	Name of a dimension, such as CUSTOMER
LEVEL_NAME	VARCHAR2(128)	NOT NULL	Name of a level in the dimension, such as WAREHOUSE
LEVEL_ID	NUMBER	NOT NULL	ID of the dimension level
DESCRIPTION	NVARCHAR2(300)		Description of the dimension level in the session language

See Also:

• "DBA_CUBE_DIM_LEVELS"

• "USER_CUBE_DIM_LEVELS"