Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_CUBE_HIERARCHIES

ALL_CUBE_HIERARCHIES describes the OLAP dimension hierarchies accessible to the current user.

Related Views

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:
  • LEVEL

  • VALUE

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