|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_LEVEL, 3 of 15
CWM2_OLAP_LEVEL package contains procedures that establish level entities for dimensions 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 does not fully define it, nor does it involve any mapping to warehouse dimension tables.
The parent dimension must already exist in the OLAP 2 Catalog before you can create levels for it. Hierarchies must already exist for the dimension before you can assign levels to them.
Creating levels is one of the steps in creating the OLAP metadata for a dimension. Once you have created the hierarchies, you will need to call procedures in the following packages to fully define the dimension's metadata: