Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube: Storage

Storage determines how the data is stored physically. These choices impact the performance of the cube. By default, cubes are compressed, have a NUMBER data type, and all dimensions except Time are treated as sparse dimensions.

Use Compression: Identifies the type of composite used to store the data: compressed or uncompressed. Most cubes are very sparse and use a compressed composite.

Data Type: Identifies the default data type for the measures in the cube.

For compressed storage, all measures in the cube must have the same data type. For uncompressed storage, measures inherit the cube data type, but you can specify a different data type for individual measures.

Depending on your selection of a data type, you may set the following additional parameters:

Use Global Composites: Determines whether the cube uses one global composite or multiple composites. An unpartitioned cube always has one composite for the cube, whether it is compressed or uncompressed. A partitioned compressed cube always has a composite for each partition. A choice between single (global) and multiple composites is available only for uncompressed, partitioned cubes.

When in doubt, do not choose this option. The cube will have one composite for each partition.

Dimension Order and Sparsity: Identifies the sparse dimensions and the storage order. Under Sparse, select the sparse dimensions. They are included in the composite, whether it is compressed or uncompressed. Dense dimensions are stored separately.

The dimension order is important for uncompressed storage, but it has no effect on compressed storage. All dimensions that you identify as sparse must be grouped together. To order the dimensions, use the arrow keys to move the sparse dimensions down the list, after the dense dimensions.

Related Topics

"Data Sources for Cubes"

"Cube Storage Formats"