|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
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.
The general steps for constructing a cube are as follows:
CWM2_OLAP_CUBEto create the cube and identify its dimensions.
CWM2_OLAP_MEASUREto create the cube's measures.
CWM2_OLAP_TABLE_MAPto 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.