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