refreshpolicy-element-assl.md

title	RefreshPolicy Element (ASSL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	RefreshPolicy Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	RefreshPolicy
helpviewer_keywords	RefreshPolicy element
ms.assetid	f4c36280-1a39-4f1c-a3ab-fbeb81742d6d
caps.latest.revision	34
author	Minewiskan
ms.author	owend
manager	erikre

RefreshPolicy Element (ASSL)

Determines how often the dynamic part of the dimension or measure group (as specified by the Persistence element) is checked for changes.

Syntax

  
<DimensionBinding> <!-- or MeasureGroupBinding -->  
   ...  
   <RefreshPolicy>...</RefreshPolicy>  
   ...  
</DimensionBinding>  

Element Characteristics

Characteristic	Description
Data type and length	String (enumeration)
Default value	See the table below.
Cardinality	0-1: Optional element that can occur once and only once.

Ancestor or Parent	Default Value
DimensionBinding	ByQuery
MeasureGroupBinding	None

Element Relationships

Relationship	Element
Parent elements	DimensionBinding, MeasureGroupBinding
Child elements	None

Remarks

The value of this element is limited to one of the strings listed in the following table.

Value	Description
ByQuery	Every query checks to see whether the source data has changed.
ByInterval	Source data is only checked for changes at the interval specified by RefreshInterval.

The enumeration that corresponds to the allowed values for RefreshPolicy in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.RefreshPolicy.

See Also

Persistence Element (ASSL)
Properties (ASSL)