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
ATTRIBUTE_NAME VARCHAR2(30)   Name of the attribute
LEVEL_NAME VARCHAR2(30)   Name of the hierarchy level
COLUMN_NAME VARCHAR2(30) NOT NULL Dependent column name
INFERRED CHAR(1)   Indicates whether the attribute is inferred from a JOIN KEY specification (Y) or not (N)