2.106 ALL_CUBE_HIERARCHIES
ALL_CUBE_HIERARCHIES
describes the OLAP dimension hierarchies accessible to the current user.
Related Views
-
DBA_CUBE_HIERARCHIES
describes all OLAP dimension hierarchies in the database. -
USER_CUBE_HIERARCHIES
describes the OLAP dimension hierarchies owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the dimension |
|
|
|
Name of a dimension, such as |
|
|
|
Name of a hierarchy for the dimension, such as |
|
|
|
ID of the hierarchy |
|
|
|
Type of the hierarchy:
|
|
|
|
Description of the hierarchy in the session language |
|
|
|
Indicates whether ragged hierarchies are permitted in subsequent builds. User dimensions that are enabled for materialized views and Time dimensions are set to |
|
|
|
Indicates whether skip-level hierarchies are permitted in subsequent builds. User dimensions that are enabled for materialized views and Time dimensions are set to |
|
|
|
Name of the Refresh Materialized View associated with the hierarchy |
|
|
|
The textual representation of the sort orderby clause used to load dimension members of the hierarchy into the AW |
See Also: