I posted the following question the MSDN Forums:

Are there any tools or tricks for looking at how an MDX query is evaluated
in SSAS 2005? Something that indicates how aggregations are being used, for
example - sort of like a SHOWPLAN for MDX.

One response mentioned using Profiler to verify whether aggregations are
being used to process the query. I have yet to figure out how to determine
this with Profiler - anyone know of a good reference for using Profiler in
this way?

The response also mentioned a PPT presentation from a SQL PASS conference on
the topic, but I'm not crazy about forking out $500 just be able to download
the presentation. Anyone know of another place where this PPT can be found?

In Profiler connect to your Analysis Server.
Go into Events selection pane and select "Show all events" checkbox.
You will see Query Processing category of events. You can select all events
from it.
If you are specifically interested in hitting aggregations, select "Get Data
From Aggregation" event.


Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights

"Kevin Dente" <kevind (AT) no (DOT) spam.denteworld.com> wrote

Aha! I was working against an older CTP of SSAS, and those options weren't
there. Now I'm on RTM, and I see them. Thanks!


"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> wrote