Problem in understanding the report

Jun 27, 2011 at 10:24 AM


I have downloded MDXScriptPerformance2008 tool and executed one mdx query. It generated for 113 mdx queries for single. Could you some one explain how mdx query is splited here and how to analyse out put columns :time Taken,   delta and   % of final query time. Our scope is to find the time taken by each mdx query when we run multiple query and find out which query is taking more time.


Thanks in advance


Jun 27, 2011 at 6:58 PM

The MDX query you paste into the app window is not modified at all. It is run repeatedly. The MDX script (the Calculations tab in the cube designer)  is what varies. Each MDX query execution is done with more and more of the MDX script to determine which statement causes the MDX query to slow down.

So this app won't really do what you're wanting.