What's New

Clear SSAS Cache

By - Apr 06, 2014

For performance testing and optimization, it is essential to measure the performance of a refresh of a form/pivot-table/query. In order to do this, you would need to ensure the SSAS cache is first cleared before you begin measuring for 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.

<Batch xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<ClearCache>
<Object>
<DatabaseID>Solution-Integrated Planning</DatabaseID>
</Object>
</ClearCache>
</Batch>

3. Run the query.
4. Now refresh the form/pivot-table/query and measure!


Facebooktwitterlinkedinmail