Showing posts with label ssas cache clearing xmla analysis services bi. Show all posts
Showing posts with label ssas cache clearing xmla analysis services bi. Show all posts

Friday, 25 November 2011

Analysis Services - Clearing the Cache

Analysis Services - Clearing the Cache

If you want to clear the analysis services cache for testing purposes you can run the following xmla command while connected to the cube in Management Studio


<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ClearCache>
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
</Object>
</ClearCache>
</Batch>