Great tool, few issues...

Mar 3, 2009 at 8:05 AM
Hello,

Thanks for posting the tool, as an SSAS newbie it was good to see the query broken down.
However the  numbers I'm getting back are jibberish:
Percentage of final query 253.67% was the largest
and some of the delta steps take a negative amount of time...
Are these known issues ?
Happy to send you the query and the report if that is helpful?

Coordinator
Mar 3, 2009 at 8:16 PM
It's just running the MDX query over and over again with increasingly more of the MDX script. So if your hardware is busy with other tasks and is returning the MDX query with inconsistent performance, that may be an explanation. Also, if the response time for a query is very small, then the deltas will be erratic.

Please do post back a copy of the report and the MDX query and we can take a look.