■ Data Analysis/SSAS (Cube)

Clear the Analysis Data Caches

Wonbae Kim 2016. 9. 16. 00:20

è  XMLA query

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

<Object>

<DatabaseID>XXX_BI_WBKIM</DatabaseID>

<CubeID>Model</CubeID>

<MeasureGroupID>Perf</MeasureGroupID>

</Object>

</ClearCache>

 

Or

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

<Object>

<DatabaseID>XXX_BI_WBKIM</DatabaseID>

<DimensionID>Customer</DimensionID>

</Object>

</ClearCache>


è [F5]

<return xmlns="urn:schemas-microsoft-com:xml-analysis">

<root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />

</return>