SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Programming Reference

Analysis Services Administration Programming

Analysis Services Scripting Language (ASSL)

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements

Objects

Account Element

Aggregation Element

AggregationDesign Element

AggregationInstance Element

AlgorithmParameter Element

AllMemberTranslation Element

Annotation Element

Assembly Element

Attribute Element

AttributeAllMemberTranslation Element

AttributePermission Element

AttributeRelationship Element

Block Element

Calculation Element

CalculationProperty Element

CaptionColumn Element

CellPermission Element

Command Element

Cube Element

CubePermission Element

CustomRollupColumn Element

CustomRollupPropertiesColumn Element

Data Element

Database Element

DatabasePermission Element

DataSource Element

DataSourcePermission Element

DataSourceView Element

Dimension Element

DimensionPermission Element

ErrorConfiguration Element

Event Element

File Element

ForeignKeyColumn Element

Group Element

Hierarchy Element

IncrementalProcessingNotification Element

KeyColumn Element

Kpi Element

Level Element

MdxScript Element

Measure Element

MeasureGroup Element

MiningModel Element

MiningModelPermission Element

MiningStructure Element

MiningStructurePermission Element

ModelingFlag Element

NameColumn Element

NamingTemplateTranslation Element

Partition Element

Perspective Element

ProactiveCaching Element

QueryNotification Element

ReportFormatParameter Element

ReportParameter Element

Role Element

ServerProperty Element

SkippedLevelsColumn Element

SourceMeasureGroup Element

TableNotification Element

Trace Element

Translation Element

UnaryOperatorColumn Element

UnknownMemberTranslation Element

ValueColumn Element

Minimize

This topic has not yet been rated - Rate this topic

ProactiveCaching Element (ASSL)

SQL Server 2005

SQL Server 2012

Defines proactive caching settings for the parent element.


<Cube> <!-- or Dimension, MeasureGroup, Partition -->
   ...
   <ProactiveCaching>
      <OnlineMode>...</OnlineMode>
      <AggregationStorage>...</AggregationStorage>
      <Source>...</Source>
      <SilenceInterval>...</SilenceInterval>
      <Latency>...</Latency>
      <SilenceOverrideInterval>...</SilenceOverrideInterval>
      <ForceRebuildInterval>...</ForceRebuildInterval>
      <Enabled>...</Enabled>
   </ProactiveCaching>
   ...
</Cube>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent elements	Cube, Dimension, MeasureGroup, Partition
Child elements	AggregationStorage, Enabled, ForceRebuildInterval, Latency, OnlineMode, SilenceInterval, SilenceOverrideInterval, Source

The corresponding element in the Analysis Management Objects (AMO) object model is ProactiveCaching.

Reference

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.