Relational and ROLAP Implementation of a Cube

The database object used to store the cube data is called a fact table. A cube must be implemented using only one fact table. The fact table contains columns for the cube measures and dimension references. For more information on setting the implementation option for a cube, see "Dimension Implementation".

To implement a cube:

• Select a table or materialized view that will store the cube data.

• For each measure, select a column that will store the measure data.

• For each dimension reference, select a column that will store the dimension reference.

  Each dimension reference corresponds to a column on the fact table and optionally a foreign key from the fact table to dimension table. The 1:n relationships from the fact tables to the dimension tables must be enforced.

Figure: Implementation of the Sales Cube displays the bindings for the relational implementation of the SALES cube. The data for the SALES cube is stored in a table called SALES.