Proactive Caching in SQL Server Analysis Services (SSAS)

Introduction

The Proactive Caching in SQL Server Analysis Services (SSAS) module provides you with the instructions and devices to develop hands on skills in the following topics:

• Implementing proactive caching in SSAS

Exercise 1 - Implementing Proactive Caching in SSAS

Implementing proactive caching in SSAS enables you to keep your cube up to date. When you enable proactive caching on your cube, SSAS automatically detects new changes to the database data based on the notification received from the database and reprocess the cube to reflect the changes.