Monday, August 29, 2011

Clear Analysis Services Cache

To test execution time of calculated measures from cold cache instead of warm cache run this query on Analysis Services MDX query editor:


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

No comments:

Post a Comment