Udostępnij za pośrednictwem


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

Ancestor or Parent

Default Value

DimensionBindingByQuery

MeasureGroupBindingNone

Cardinality

0-1: Optional element that can occur once and only once.

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

See Also

Reference

Persistence Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance