Creating Levels

The CWM2_OLAP_LEVEL package contains procedures that establish level entities for dimensions within the OLAP 2 Catalog.

Note: 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.

Completing the Dimension's Metadata

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:

• CWM2_OLAP_DIMENSION_ATTRIBUTE to create dimension attributes (if you have not already done so)
• CWM2_OLAP_LEVEL_ATTRIBUTE to create level attributes and assign them to dimension attributes
• CWM2_OLAP_TABLE_MAP to map levels and level attributes to columns in one or more dimension tables