Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
OLAP Catalog (CWM2-Specific) Views , 12 of 25
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.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|