Skip to content

Latest commit

 

History

History
22 lines (19 loc) · 1.24 KB

File metadata and controls

22 lines (19 loc) · 1.24 KB
title Proactive Caching (Dimensions) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic reference
helpviewer_keywords
dimensions [Analysis Services], proactive caching
proactive caching [Analysis Services]
ms.assetid 7d57fe93-6e5f-4a50-844f-dd2bbdbb94a5
author minewiskan
ms.author owend
manager craigg

Proactive Caching (Dimensions)

Proactive caching provides automatic MOLAP cache creation and management for OLAP objects. The cubes immediately incorporate changes that are made to the data in the database, based upon notifications received from the database. The goal of proactive caching is to provide the performance of traditional MOLAP, while retaining the immediacy and ease of management offered by ROLAP.

A simple xref:Microsoft.AnalysisServices.ProactiveCaching object is composed of: timing specification, and table notification. The timing specification defines the timeframe for updating the cache after a change notification has been received. The table notification defines the notification schema between the data table and the xref:Microsoft.AnalysisServices.ProactiveCaching object.