• Article

Storage Settings Dialog Box (Analysis Services - Multidimensional Data)

Use the Storage Settings dialog box in Business Intelligence Development Studio 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 Business Intelligence Development Studio by:

  • Clicking the ellipsis button (...) for the ProactiveCaching property value of a dimension, cube, measure group, or partition in the Properties window of Business Intelligence Development Studio.

  • 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:

SettingDescription
Real-time ROLAPSelect 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 HOLAPSelect 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 MOLAPSelect 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 MOLAPSelect 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 MOLAPSelect 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 MOLAPSelect 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

MOLAPSelect 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).