Using Proactive Caching
Proactive caching enables your end users to access your BI data with all the speed and power of SSAS but without the typical latency (often one business day) between the OLTP source and OLAP data. Configuring proactive caching is the method by which you manage the MOLAP cache.
The MOLAP cache is an in-memory storage location created automatically by SSAS. The cache includes fact and dimension data and occasionally aggregations. This information is placed in the cache area after MDX queries are executed against the SSAS cubes. Figure 6–13 shows a conceptual rendering of the MOLAP cache.
Figure 6–13. Proactive caching ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
