본문 바로가기
Microsoft BI

Clear the Analysis Data Caches

è  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>

 

'Microsoft BI' 카테고리의 다른 글

SQL Trace (Save to file)  (0) 2016.10.25
Configuring HTTP Access for Analysis Services(Tabular model)  (0) 2016.09.17
Tabular Display Folders  (0) 2016.09.16
OLAP PivotTable Extensions  (0) 2016.09.15
Job Scheduler (Tabular Model)  (0) 2016.09.13