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 ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.