Proactive Caching

SSAS supports three storage modes:

·         MOLAP - stores detailed data and aggregations in a compressed, proprietary format; i.e. a complete copy of the data is made but query performance is excellent

·         HOLAP - stores aggregations same as MOLAP, detailed data is accessed as required from the relational data source

·         ROLAP - accesses detailed data and aggregations from the relational data source

Note that with MOLAP or HOLAP storage, the cube becomes out of date as soon as the relational data source changes.  Proactive Caching is a feature in SSAS that allows you to specify when to process a measure group partition or dimension as the data in the relational data source changes.  When Proactive Caching is implemented, SSAS will handle keeping the cube up to date on its own, per the parameters you specify.  The alternative to Proactive Caching is to develop an SSIS package that processes the dimensions and measure group partitions; you would execute the SSIS package periodically.

Configuring proactive caching

The proactive caching feature ensures a cube or a measure group partition or dimension reflects current data on its own. Depending on your choice of proactive caching enabled storage mode, interception of data change notification, storage location and update frequency will vary.

1. In the Cube Browser, open your cube and select the Partitions tab.
2. Expand the measure group and select the partition for which you want to enable proactive caching.
3. Click the Storage Setting link to open the Partition Storage Settings dialog box.

4.       Move the Standard Setting slider to storage mode as per your requirement.

STANDARD SETTINGS:

A. MOLAP

B. Scheduled MOLAP

C.Automatic MOLAP

 

D. Medium Latency MOLAP

E. Low Latency MOLAP

F.  Real Time HOLAP

G. Real Time ROLAP