Storage Settings Dialog Box (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

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.

TermSettings and Options DefinitionDetails
Standard settingSelect to enable Standard setting slider and use predefined settings for storage mode and proactive caching features.
Standard setting sliderSet to one of the following predefined settings:
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 settingSelect to explicitly set storage mode, proactive caching, and notification options.
OptionsClick 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).

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Proactive Caching (Partitions)
Cube Storage (Analysis Services - Multidimensional Data)

Community Additions

ADD
Show: