Clear SSAS Cache
By Kepion Solution - 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.
3. Run the query.
4. Now refresh the form/pivot-table/query and measure!