Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

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.