ALL_DIM_ATTRIBUTES

ALL_DIM_ATTRIBUTES describes the relationship between a dimension level and a functionally dependent column. The level columns and the dependent column must be in the same table.

Related Views

• DBA_DIM_ATTRIBUTES describes all such dimension relationships in the database.
• USER_DIM_ATTRIBUTES describes all such dimension attributes in the current user's schema.

  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)		Name of the hierarchy level
  COLUMN_NAME	VARCHAR2(30)	NOT NULL	Dependent column name
  INFERRED	CHAR(1)		Whether inferred