Configuring Storage
You can use the Storage Settings dialog box to configure storage. To open the Storage Settings dialog box, in Cube Designer, on the Partitions tab, click Storage Settings. This allows you to pick one of the standard settings for relational OLAP (ROLAP), hybrid OLAP (HOLAP), or multidimensional OLAP (MOLAP) storage, or to configure custom settings for the storage mode and proactive caching. Storage can be configured separately for each partition of each measure group in a cube. You can also configure the default storage settings for a cube or measure group. Storage is configured on the Partitions tab in the Cube Wizard. The Partitions tab lists the measure groups in a cube. You can expand any measure group to view its partitions. Storage settings for partitions are set in the Storage Options dialog box, which can be opened in one of several different ways.
| To Configure | Do this |
|---|---|
Default storage settings for new measure groups added to a cube |
On the Cube Builder tab in the Cube Wizard, click the cube object in either the Measures or Dimensions pane, and then in the Properties window, click the browse (...) button for the ProactiveCaching property setting. |
Default storage settings for new partitions added to a measure group |
On the Partitions tab in the Cube Wizard, expand the measure group and click the Storage Settings link for that measure group. This displays the Storage Settings dialog box for the selected measure group. |
Configure storage for an existing partition |
On the Partitions tab in the Cube Wizard, expand the measure group, and use one of the following methods:
|
Configure storage while designing aggregations |
Run the Aggregation Design Wizard. For more information, see Designing Aggregations (SSAS). |
See Also
Concepts
Designing Partition Storage and Aggregations
Choosing a Standard Storage Setting
Setting Custom Storage Settings