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

Kepion Modeler

Build Enterprise BI & CPM solutions within minutes with Kepion Modeler.



Connect with Us

    Facebooktwitterlinkedinyoutube