Constructing a Cube

Creating a cube entity is only the first step in constructing the OLAP metadata for a cube. Each cube must have at least one dimension and at least one measure. More typically, it will have multiple dimensions and multiple measures.

Procedure: Construct an OLAP Cube

The general steps for constructing a cube are as follows:

1. Follow the steps in "Procedure: Construct an OLAP Dimension" to create the cube's dimensions.
2. Call procedures in CWM2_OLAP_CUBE to create the cube and identify its dimensions.
3. Call procedures in CWM2_OLAP_MEASURE to create the cube's measures.
4. Call procedures in CWM2_OLAP_TABLE_MAP to map the cube's measures to columns in a fact table and to map foreign key columns in the fact table to key columns in the dimension tables.