Just a short note about analysis services and its cache 🙂
One of the reasons for analysis services fast respond time is its cahce. But what if you want to test a query without using the cache? Well, just use this XMLA Script:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <ClearCache> <Object> <DatabaseID>Your Database Goes here </DatabaseID> <CubeID>And or cube id goes here</CubeID> </Object> </ClearCache> </Batch>
Also, if you do partial processing, the cache, can in some cases also be invalid. Therefore, after a partial processing, you also want to run the above XMLA script.