O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image

Figure 6–13. Proactive caching ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required