Storage Settings Dialog Box (SSAS)
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:
Setting
Description
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 (SSAS).
See Also
Reference
Analysis Services Designers and Dialog Boxes (SSAS)
Other Resources
Proactive Caching
Cube Storage (Analysis Services)