| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
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 the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of a dimension, such as TIME |
HIERARCHY_NAME |
VARCHAR2(30) |
NOT NULL |
Name of a hierarchy for the dimension, such as CALENDAR |
HIERARCHY_TYPE |
VARCHAR2(5) |
Type of the hierarchy:
|
|
DESCRIPTION |
NVARCHAR2(300) |
Description of the hierarchy in the session language | |
IS_RAGGED |
NUMBER |
Indication of whether the hierarchy is ragged | |
IS_SKIP_LEVEL |
NUMBER |
Indication of whether the hierarchy is skip level |
