ClearCache Element (XMLA)

  • Article

Clears the memory cache for the specified object on a Microsoft SQL Server 2005 Analysis Services (SSAS) instance.

Syntax

<Command>
   <ClearCache>
      <Object>...</Object>
   </ClearCache>
</Command>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element

Parent elements

Command

Child elements

Object

Remarks

The ClearCache command flushes the cache for a specified database, dimension, cube, measure group, or partition on an Analysis Services instance. If an object other than a database, dimension, cube, measure group, or partition is specified in the Object element, an error occurs.

See Also

Concepts

Commands (XMLA)

Help and Information

Getting SQL Server 2005 Assistance