ALL_DIM_LEVELS

ALL_DIM_LEVELS describes the dimension levels accessible to the current user. All columns of a dimension level must come from the same relation.

Related Views

• DBA_DIM_LEVELS describes all dimension levels in the database.
• USER_DIM_LEVELS describes the levels of all dimensions owned by the current user.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
  DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
  LEVEL_NAME	VARCHAR2(30)		Unique within a dimension
  NUM_COLUMNS	NUMBER		Number of columns in the level definition
  DETAILOBJ_OWNER	VARCHAR2(30)	NOT NULL	Owner of the detail object that the keys of this level come from
  DETAILOBJ_NAME	VARCHAR2(30)	NOT NULL	Name of the table that the keys of this level come from