ALL$OLAP2_DIM_ATTR_USES

Each row represents the association of a level attribute with a dimension attribute. A dimension attribute is composed of a set of level attributes. The same level attribute can be included in more than one dimension attribute.

A level attribute designates a column in a dimension table that stores descriptive information about a level in the dimension. For example, there might be a color attribute pertaining to a product ID level.

A dimension attribute is a collection of level attributes. For example, the TIME_SPAN dimension attribute stores the number of days associated with each time period in a time dimension. Time periods are defined as levels, and each level has its own associated TIME_SPAN level attribute, but all the TIME_SPAN level attributes (for example, MONTH_TIME_SPAN, QUARTER_TIME_SPAN, and YEAR_TIME_SPAN) are defined as a single TIME_SPAN dimension attribute.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension.
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension.
DIM_ATTRIBUTE_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension attribute.
LEVEL_NAME	VARCHAR2(30)	NOT NULL	Name of a level within the dimension.
LVL_ATTRIBUTE_NAME	VARCHAR2(30)	NOT NULL	Name of an attribute for this level. This level attribute is included in the dimension attribute.