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