Share via


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:

  • Right-click the partition, and then click Storage Settings.
  • Click the partition, and then on the Cube menu, click Storage Settings.
  • Click the partition, and then on the toolbar, click the Set Proactive-cache Settings buttons.
  • Click the partition, and then in the Properties window, click the browse (...) button for the ProactiveCaching property setting.

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

Help and Information

Getting SQL Server 2005 Assistance