RefreshPolicy Element (ASSL)

 

Applies To: SQL Server 2016 Preview

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

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

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueSee the table below.
Cardinality0-1: Optional element that can occur once and only once.
Ancestor or ParentDefault Value
DimensionBindingByQuery
MeasureGroupBindingNone
RelationshipElement
Parent elementsDimensionBinding, MeasureGroupBinding
Child elementsNone

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

ValueDescription
ByQueryEvery query checks to see whether the source data has changed.
ByIntervalSource 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 RefreshPolicy.

Persistence Element (ASSL)
Properties (ASSL)

Community Additions

ADD
Show: