A long time ago I posted a blog entry explaining how to do an effective restart of SQL Server. I have no idea whether its proved useful to anyone else but it has been invaluable to me because I'm forever needing to know how to do this and I can never remember the syntax.
Well for the very same reason I'm posting up here the XMLA command for clearing the Analysis Services cache as well. Here it is:
<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
</Object>
</ClearCache>
My thanks to the newly anointed MVP Darren Gosbell who told me how to do this!
-Jamie