ALL_OLAP2_DIMENSIONS

ALL_OLAP2_DIMENSIONS is a synonym for ALL$OLAP2UDIMENSIONS.

Each row represents a dimension. In OLAP 1 metadata, dimensions are based on Oracle dimension objects. In OLAP 2 metadata, dimensions are completely independent of Oracle dimension objects.

Column	Data Type	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension.
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension.
PLURAL_NAME	VARCHAR2(30)		Plural name for the dimension. Used for display.
DISPLAY_NAME	VARCHAR2(30)		Display name for the dimension.
DESCRIPTION	VARCHAR2(2000)		Description of the dimension.
DEFAULT_DISPLAY_HIERARCHY	VARCHAR2(30)	NOT NULL	Default display hierarchy for the dimension.
INVALID	VARCHAR2(1)	NOT NULL	Whether or not the dimension is valid. A dimension is valid when all of its levels and level attributes are mapped to existing columns, any dimension attributes are defined with sets of valid level attributes, and hierarchies are defined with valid levels.
DIMENSION_TYPE	VARCHAR2(10)		Not used.