SSAS Clear Cache snippet
So, this code snippet is all over the internet, but sometimes I just want to know where I can find it without asking Uncle Google every time.
This XMLA code snippet is for clearing the SSAS cache for performance tuning.
<ClearCache xmlns='http://schemas.microsoft.com/analysisservices/2003/engine'> <Object> <DatabaseID>your database ID here</DatabaseID> </Object> </ClearCache>
01 May 2014 Permalink analysis