ALL_DIM_ATTRIBUTES

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