Skip Headers
Previous
Previous
 
Next
Next

Creating Cubes

Cubes organize measures with the exact same cube dimensions. These measures are loaded, aggregated, stored, and queried together. A cube corresponds to a fact table or view.


Note:

If your fact table has many columns of data, then you should create a cube with a measure dimension. See "Creating Measure Dimensions and Pivot Cubes."

To create a cube: 

  1. In the Connections navigator, right-click Cubes and choose New Cube.

  2. Complete all fields of the General panel. When creating an uncompressed cube, follow these rules when ordering the dimensions:

    • List the Time dimension first to expedite data loading and time series analysis. Time is often a dense dimension, although it may be sparse if the detail level is Day or the cube has many dimensions.

    • List the sparse dimensions in order from the one with the most members to the one with the least.

NEXT: Creating Measures

Related Topics

"About Cubes"