This topic has not yet been rated - Rate this topic

Managing Caches (XMLA)

SQL Server 2008

You can use the ClearCache command in XML for Analysis (XMLA) to clear the cache of a specified dimension or partition. Clearing the cache forces Microsoft SQL Server Analysis Services to rebuild the cache for that object.

Specifying Objects

The Object property of the ClearCache command can contain an object reference only for one of the following objects. An error occurs if an object reference is for an object other than one of following objects:

Database: Clears the cache for all dimensions and partitions contained in the database.
Dimension: Clears the cache for the specified dimension.
Cube: Clears the cache for all partitions contained in the measure groups for the cube.
Measure group: Clears the cache for all partitions contained in the measure group.
Partition: Clears the cache for the specified partition.

Concepts

Using XML for Analysis in Analysis Services (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD