O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Proactive Caching

Wouldn’t it be terrific if your BI solution allowed end users to access data with all the query response speed and flexibility of SSAS, yet also allowed them to use a solution that didn’t require the typical latency (often one business day) between the OLTP source data and OLAP data? That’s the concept behind proactive caching. Think of configuring proactive caching as the method by which you manage the MOLAP cache.

What is the MOLAP cache? It’s an in-memory storage location created automatically by SSAS. The cache includes actual data and, sometimes, aggregations. This information is placed in the cache area after MDX queries are executed against the SSAS cubes. Figure 9-14 shows a conceptual rendering of the MOLAP cache.

Figure 9-14. Proactive ...

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