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 of the dimension |
|
|
|
|
Name of the dimension |
|
|
|
Name of the attribute |
|
|
|
|
Name of the hierarchy level |
|
|
|
|
|
Dependent column name |
|
|
|
Indicates whether the attribute is inferred from a JOIN KEY specification ( |
See Also: