Proactive Caching and Real-Time Updates - Microsoft SQL Server 2008 Analysis Services - page 437

FIGURE 24.4

The Proactive Caching page enables you to define proactive caching properties.

If you select this scenario, Analysis Services will reprocess the MOLAP cache for the Store
dimension daily.

NOTE
Use this property with caution. Don't expect Analysis Services to start processing a
new version of the object at some specific hour in the day. The calculation Analysis
Services makes to start processing depends on the LastProcessed timestamp on the
object. Analysis Services simply checks whether the sum of the values of
LastProcessed and ForceRebuildInterva l is smaller than the value of the current
time. For example, you can't rely on this property to start your processing at midnight.
The start time for processing depends on how long the previous processing takes.
Use SQL Server Agent to schedule processing of an object at a specific time.

Automatic MOLAP Scenario

The values for properties in this scenario are as follows:

. SilenceInterval = 10 sec

. SilenceOverrideInterval = 10 min

. Latency = -1 (infinite)