Home > Creating Dimensional Objects > Creating Cubes
![]() Previous |
![]() Next |
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:
In the Connections navigator, right-click Cubes and choose New Cube.
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