Skip to main content
MDX-How do I clear Analysis Services (SSAS) database cache?
Entry Date: Rate:
Site:
Keywords:
RSS Description:

Q: How do I clear Analysis Services (SSAS) database cache?

A: To clear a cache you should use XMLA command ClearCache. You can choose to clear cache for database, cube or measure group. Note: you should specify object IDs and not names. In many cases this might not be the same. To see ID of the object you can open database in the BIDS, then select object (database, cube or measure group) and check value for property ID.

Comments:

Clearing the cache is quite an important thing to do to check how well performs a given MDX query, how to make it using an XMLA script.