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>

No comments:

Post a Comment