SSAS Query Processor optimises the evaluation of calculations through storing calculation results in query processor cache, which allows expensive calculation reused within a query, a user session, or global context scope. However, we often need to clear the cache when using SQL Server Profiler to analyse slow running MDX queries. As the figure shown below, we could not get actually MDX Query execution trace as SSAS Query Processor is fetching the result from cache.
To clear the cache, we could go to SSMS and execute the following Analysis Services XMLA query.
By the way, another very useful tool for edit and debug MDX query is MDX Studio http://www.sqlbi.com/tools/mdx-studio, which provides a handy query execution statistics panel with some very useful infos.