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

See Also:

• "DBA_CUBE_HIERARCHIES"

• "USER_CUBE_HIERARCHIES"