Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Storage Design Wizard

SQL Server 2000

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

Show:
© 2015 Microsoft