ALL$OLAP2_DIMENSIONS

Each row represents an OLAP dimension. These dimensions are completely defined within OLAP 2 metadata and have no relationship to Oracle dimension objects.

Column	Datatype	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)		The dimension may be a time dimension or a normal dimension.