|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_LEVEL_ATTRIBUTE , 3 of 12
CWM2_OLAP_LEVEL_ATTRIBUTE package contains procedures that establish entities for level attributes within the OLAP 2 Catalog.
When you create an OLAP metadata entity, you are simply adding a row to an OLAP Catalog table that identifies all the entities of that type. Creating a level attribute does not involve any mapping to warehouse dimension tables.
The parent dimension, parent level, and parent dimension attribute must already exist in the OLAP 2 Catalog before you can create a level attribute.
Creating level attributes is one of the final steps in creating the OLAP metadata for a dimension. Once you have created the level attributes, you have probably created all the entities that comprise the dimension. You then need to call procedures in the CWM2_OLAP_TABLE_MAP package to map levels and level attributes to columns in one or more dimension tables.