Creating Cubes

Cubes define the shape of your business measures. They are defined by a set of dimensions. The dimensions form the edges of a cube, and the measures are the cells in the body of the cube.

To create a cube:

1. Expand the folder for the analytic workspace.

2. Right-click Cubes, then choose Create Cube from the pop-up menu.

   The Create Cube dialog box is displayed.

3. Complete the General and Aggregation tabs.

4. Click Create.

   The new cube appears as a subfolder under Cubes.

5. Create and map the measures of the cube.

6. Generate optimizer statistics if needed. In the navigation tree, right-click the cube and choose Analyze Cube.

   Queries against a single cube do not use optimizer statistics. These queries are automatically optimized within the analytic workspace.

Copyright © 2003, 2007, Oracle. All rights reserved.