Uncategorized

Clear cube or dimesion cache

<!--Database-->
<Batch xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
  <ClearCache>
    <Object>
      <DatabaseID>TestDW</DatabaseID>
    </Object>
  </ClearCache>
</Batch>

<!--Measure group-->
<Batch xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
  <ClearCache>
    <Object>
      <DatabaseID>TestDW</DatabaseID>
      <CubeID>TestCube</CubeID>
      <MeasureGroupID>Sales</MeasureGroupID>
    </Object>
  </ClearCache>
</Batch>

<!--Dimension-->
<Batch xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine">
  <ClearCache>
    <Object>
      <DatabaseID>TestDW</DatabaseID>
      <DimensionID>Dim Customer</DimensionID>
    </Object>
  </ClearCache>
</Batch>