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