Storage Design Wizard

Analysis Services

Analysis Services

Storage Design Wizard

Use this wizard to specify data storage and query performance options for the aggregations on a cube or partition.

The Storage Design Wizard appears when, in the Analysis Manager tree pane, you expand the Cubes folder, right-click an existing cube, and then click Design Storage.

This wizard also appears when you expand the Partitions folder for an existing cube, right-click an existing cube partition, and then click Design Storage.

The Storage Design Wizard has the following steps:

  • Select the type of data storage for your cube or partition: multidimensional OLAP (MOLAP), relational OLAP (ROLAP), or hybrid OLAP (HOLAP).

  • Design aggregations for your cube or partition based on aggregation storage size and query performance options.

  • Process the aggregations or save and process the aggregations later.

See Also

Cube Storage

Aggregations