Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Managing Caches (XMLA)

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 2005 Analysis Services (SSAS) to rebuild the cache for that object.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.