ALL_OLAP2_DIM_HIERARCHIES

ALL_OLAP2_DIM_HIERARCHIES is a synonym for ALL$OLAP2UDIM_HIERARCHIES.

Each row represents a dimension hierarchy. The relationships between levels for each hierarchy are represented by ALL_OLAP2_DIM_HIER_LEVEL_USES.

Column	Data Type	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension.
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension.
HIERARCHY_NAME	VARCHAR2(30)	NOT NULL	Name of the hierarchy.
DISPLAY_NAME	VARCHAR2(30)		Display name for the hierarchy.
DESCRIPTION	VARCHAR2(2000)		Description of the hierarchy.
SOLVED_CODE	VARCHAR2(2)	NOT NULL	The solved code may be one of the following: UNSOLVED LEVEL-BASED, for a hierarchy that contains no embedded totals and is stored in a level-based dimension table. Release 1 hierarchies are always of this type. SOLVED LEVEL-BASED, for a hierarchy that contains embedded totals, has a grouping ID, and is stored in a level-based dimension table. (Release 2 hierarchies only) SOLVED VALUE-BASED, for a hierarchy that contains embedded totals for all level combinations and is stored in a parent/child dimension table. (Release 2 hierarchies only)