ALL_CUBE_HIERARCHIES
ALL_CUBE_HIERARCHIES describes the OLAP dimension hierarchies accessible to the current user.
Related Views
-
DBA_CUBE_HIERARCHIESdescribes all OLAP dimension hierarchies in the database. -
USER_CUBE_HIERARCHIESdescribes the OLAP dimension hierarchies owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(128) |
NOT NULL |
Name of a dimension, such as TIME |
HIERARCHY_NAME |
VARCHAR2(128) |
NOT NULL |
Name of a hierarchy for the dimension, such as CALENDAR |
HIERARCHY_ID |
NUMBER |
NOT NULL |
ID of the hierarchy |
HIERARCHY_TYPE |
VARCHAR2(5) |
Type of the hierarchy:
|
|
DESCRIPTION |
NVARCHAR2(300) |
Description of the hierarchy in the session language | |
IS_RAGGED |
NUMBER |
Indicates whether ragged hierarchies are permitted in subsequent builds. User dimensions that are enabled for materialized views and Time dimensions are set to 0. Builds then check the data for ragged hierarchies and fail if one is detected. When User dimensions are set to 1, the builds do not check for ragged hierarchies. |
|
IS_SKIP_LEVEL |
NUMBER |
Indicates whether skip-level hierarchies are permitted in subsequent builds. User dimensions that are enabled for materialized views and Time dimensions are set to 0. Builds then check the data for skip-level hierarchies and fail if one is detected. When User dimensions are set to 1, the builds do not check for skip-level hierarchies. |
|
REFRESH_MVIEW_NAME |
VARCHAR2(200) |
Name of the Refresh Materialized View associated with the hierarchy | |
CUSTOM_ORDER |
CLOB |
The textual representation of the sort orderby clause used to load dimension members of the hierarchy into the AW |
See Also: