Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
ProactiveCachingproperty 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 | Values |
|---|---|---|
| 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: 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
Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Proactive Caching (Partitions)
Cube Storage (Analysis Services - Multidimensional Data)