How to Clear SSAS Cache?

By - Updated May 28, 2015

For performance testing and optimization, it is very useful to measure the raw performance of a form refresh (how long it takes to refresh the form from a cold start). In order to do this, you would need to ensure the SSAS cache is cleared before you measure any response times.

Here’s what we need to do.

1. Connect to Analysis Service. Open a new XMLA query.

2. Paste the following code into the query. Change the DatabaseID (highlighted in gray) to your database name.

3. Run the query.