Creating Cubes

The CWM2_OLAP_CUBE package contains procedures that establish cube 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's Dimensions

Before you create a cube, you must create its 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 Cube's Metadata

Once you have created a cube, you will need to call procedures in the following packages to fully define the cube's metadata:

• CWM2_OLAP_MEASURE to create measures and add them to the cube
• CWM2_OLAP_TABLE_MAP to establish the mapping to columns in one or more fact tables

Verifying the Metadata for a Cube

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 CWM2_OLAP_VALIDATE package.

To test the validity of the cube itself, use the VALIDATE_CUBE procedure in the CWM2_OLAP_VALIDATE package.