|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_MEASURE, 3 of 12
CWM2_OLAP_MEASURE package contains procedures that establish measure entities 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 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.
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:
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.