|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_CUBE, 3 of 16
CWM2_OLAP_CUBE package contains procedures that establish cube 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 cube, you must create its dimensions by calling procedures in the following packages:
Once you have created a cube, you will need to call procedures in the following packages to fully define the cube's metadata:
To be valid, a cube must have at least one valid dimension and at least one measure that is correctly mapped to a column in a fact table.
To test the validity of the cube's dimensional metadata, use the
VALIDATE_DIMENSION procedure in the
To test the validity of the cube itself, use the
VALIDATE_CUBE procedure in the