2.120 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 of the dimension |
|
|
|
Name of the dimension |
|
|
|
Unique within a dimension |
|
|
|
Number of columns in the level definition |
|
|
|
Owner of the detail object that the keys of this level come from |
|
|
|
Name of the table that the keys of this level come from |
|
|
|
Indicates whether the level is declared with the |
See Also: