|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_LEVEL_ATTRIBUTE , 2 of 12
A level attribute is an OLAP metadata entity. This means that it is a logical object, identified by name and owner, within the OLAP 2 Catalog.
A level attribute is a child entity of a level, and it may be a child entity of one or more dimension attributes.
A level attribute stores descriptive information about its related level. For example, a level containing product identifiers might have an associated level attribute that contains color information for each product.
Each level attribute maps to a column in a dimension table. The level attribute column must be in the same table as the column (or columns) for its associated level. If the dimension is stored in a parent/child table instead of a level-based table, level attributes map to columns in the view you can generate via the
CWM2_OLAP_PC_TRANSFORM package. Similarly, if the dimension is stored in an analytic workspace, level attributes map to columns in the view you can generate via the