How can I clear the Analysis Services cache without restarting?
You can use an XMLA Script like the following (replacing “{YOUR SSAS DB ID HERE}” with the valid Database ID:
<ClearCache xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<Object>
<DatabaseID>{YOUR SSAS DB ID HERE}</DatabaseID>
</Object>
</ClearCache>
The nice thing about this approach is you can test a specific statement’s execution by prefacing it with this command.