Creating Measures

The CWM2_OLAP_MEASURE package contains procedures that establish measure entities 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 an entity of metadata does not fully define a dimension or a cube, nor does it involve any mapping to warehouse dimension tables or fact tables.

Creating a Cube for the Measure

Before you create a measure, you must create the cube that will provide its context. To create the cube, use procedures in the CWM2_OLAP_CUBE package.

Prior to creating the cube, you must create the cube's dimensions by calling procedures in the following packages:

• CWM2_OLAP_DIMENSION
• CWM2_OLAP_DIMENSION_ATTRIBUTE
• CWM2_OLAP_HIERARCHY
• CWM2_OLAP_LEVEL
• CWM2_OLAP_LEVEL_ATTRIBUTE

Completing the Measure's Metadata

Once you have created a measure, you will need to call procedures in the CWM2_OLAP_TABLE_MAP package to establish the mapping to columns in one or more fact tables.