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.