XMLA清空Cube缓存

调优时，有时需要清空缓存来对比。使用xmla命令clearcache来完成。
清空整个库的缓存：
<ClearCache xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine" >
    < Object >
        <DatabaseID >Adventure Works DW < /DatabaseID >
    < / Object >
< /ClearCache >

清空单个cube的缓存：
<ClearCache xmlns = "http://schemas.microsoft.com/analysisservices/2003/engine" >
    < Object >
        <DatabaseID >Adventure Works DW < /DatabaseID >
        <CubeID >Adventure Works DW < /CubeID >
    < / Object >
< /ClearCache >
不支持清除单个分区的缓存

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/xiongnanbin/archive/2013/01/23/2872888.html