ALL_OLAP2_DIM_ATTRIBUTES lists the dimension attributes within each dimension.
Column
Data Type
NULL
Description
OWNER
VARCHAR2(30)
NOT NULL
Owner of the dimension.
DIMENSION_NAME
VARCHAR2(30)
NOT NULL
Name of the dimension.
ATTRIBUTE_NAME
VARCHAR2(30)
NOT NULL
Name of the dimension attribute.
DISPLAY_NAME
VARCHAR2(30)
Display name for the dimension attribute.
DESCRIPTION
VARCHAR2(2000)
Description of the dimension attribute.
DESC_ID
NUMBER
If the attribute is reserved, its type is listed in this column. Examples of reserved dimension attributes are long and short descriptions and time-related attributes, such as end date, time span, and period ago.