Storage Settings Dialog Box (Analysis Services - Multidimensional Data)

  • Article

Use the Storage Settings dialog box in SQL Server Data Tools (SSDT) to set the proactive caching, storage, and notification settings for a dimension, cube, measure group, or partition. You can display the Storage Settings dialog box in SQL Server Data Tools (SSDT) by:

  • Clicking the ellipsis button (...) for the ProactiveCaching property value of a dimension, cube, measure group, or partition in the Properties window of SQL Server Data Tools (SSDT).

  • Expanding a measure group in the Partitions tab of Cube Designer and clicking Storage Settings.

  • Expanding a measure group and selecting a partition in the grid for that measure group in the Partitions tab of Cube Designer and clicking Storage Settings.

  • Expanding a measure group and selecting a partition in the grid for that measure group in the Partitions tab of Cube Designer and clicking Storage settings in the Toolbar pane on the Partitions tab of Cube Designer.

Options

Term

Definition

Standard setting

Select to enable Standard setting slider and use predefined settings for storage mode and proactive caching features.

Standard setting slider

Set to one of the following predefined settings:

Setting

Description

Real-time ROLAP

Select to use the following storage and proactive caching settings:

  • ROLAP storage mode

  • Enables proactive caching

  • Drops outdated cache, with a latency period of 0 seconds

  • Brings object online immediately

Real-time HOLAP

Select to use the following storage and proactive caching settings:

  • HOLAP storage mode

  • Enables proactive caching

  • Drops outdated cache, with a latency period of 0 seconds

  • Updates cache when data changes, with a silence interval of 0 seconds and no silence override interval

  • Brings object online immediately

Low-latency MOLAP

Select to use the following storage and proactive caching settings:

  • MOLAP storage mode

  • Enables proactive caching

  • Drops outdated cache, with a latency period of 30 minutes

  • Updates cache when data changes, with a silence interval of 10 seconds and a silence override interval of 10 minutes

  • Brings object online immediately

Medium-latency MOLAP

Select to use the following storage and proactive caching settings:

  • MOLAP storage mode

  • Enables proactive caching

  • Drops outdated cache, with a latency period of 4 hours

  • Updates cache when data changes, with a silence interval of 10 seconds and a silence override interval of 10 minutes

  • Brings object online immediately

Automatic MOLAP

Select to use the following storage and proactive caching settings:

  • MOLAP storage mode

  • Enables proactive caching

  • Updates cache when data changes, with a silence interval of 0 seconds and no silence override interval

Scheduled MOLAP

Select to use the following storage and proactive caching settings:

  • MOLAP storage mode

  • Enable proactive caching

  • Updates cache periodically, with a rebuild interval of 1 day

MOLAP

Select to use the following storage and proactive caching settings:

  • MOLAP storage mode

Custom setting

Select to explicitly set storage mode, proactive caching, and notification options.

Options

Click to display the Storage Options dialog box to explicitly set storage mode, proactive caching, and notification options. For more information about the Storage Options dialog box, see Storage Options Dialog Box (Analysis Services - Multidimensional Data).

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Proactive Caching (Partitions)

Cube Storage (Analysis Services - Multidimensional Data)