Analyzing MDX query evaluation

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.
As you might know, AS 2005 MDX query execution events are now captured in SQL Server Profiler. What's not as clear from the docs (that I've come across, anyway) is the aggregation usage info available via SQL Profiler. This was well explained at the recent SQL PASS Conference, in Session 108: "Understanding Analysis Services 2005 Aggregations from Every Angle", by Dave Wickert and Len Wyatt:

>>
SQL Profiler

Will tell you when:
an aggregation is used for a query
the partition data is used for a query

It won’t tell you why it decides to use or not use a particular aggregation

§>>

|||Deepak,
Thanks, that sounds very promising. Do you know where I can find more information about using Profiler for this purpose? That SQL PASS session doesn't appear to be downloadable (that I can find, at least), and the documentation isn't much help here (as you point out).
Thanks,
Kevin
|||Hi Kevin,

If you're a PASS member, then the presentation slides should be downloadable, or you can order the physical media with MP3 sound. Now maybe Dave and Len are making their presentation (or equivalent info) available elsewhere - don't know!

http://www.softconference.com/250927
>>

CO1: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for attendees of the 2005 PASS Summit) CDROM (Attendees only) $ 195.00 CO2: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for members of PASS who did not attend the 2005 Summit) CDRom (Members only) $ 395.00 CO3: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for non-attendees, non-members of PASS) CDRom $ 595.00

>>

Analyst Services

Hello,
I have just down loaded SQL 2000 evaluation edition as I
need to train myself up on Analyst Services however it
does not appear on my list, can anyone help ?
"Patricia" <anonymous@.discussions.microsoft.com> wrote in message
news:121d01c4de9c$b6badae0$a601280a@.phx.gbl...
> Hello,
> I have just down loaded SQL 2000 evaluation edition as I
> need to train myself up on Analyst Services however it
> does not appear on my list, can anyone help ?
>
What do you mean it doesn't appear on your list? What list are you
referring to?
You do have to run a separate install to get the Analysis services up and
running. When you do your install, you can choose pre-components, SQL
Server and then a separate item for Analysis services.
Ensure that you get the latest service packs and apply them to both the SQL
Server and the Analysis services. (SP3a is the latest for SQL Server 2000).
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||"Patricia" <anonymous@.discussions.microsoft.com> wrote in news:121d01c4de9c
$b6badae0$a601280a@.phx.gbl:

> Hello,
> I have just down loaded SQL 2000 evaluation edition as I
> need to train myself up on Analyst Services however it
> does not appear on my list, can anyone help ?
>
Analysis Services is a seperate install? I don't know if it is included in
the evaluation. Anyway. Start install, click SQL Server 2000 Components
then click Install Analysis Services. Good Luck!
Regards JTC ^..^

Analyst Services

Hello,
I have just down loaded SQL 2000 evaluation edition as I
need to train myself up on Analyst Services however it
does not appear on my list, can anyone help ?"Patricia" <anonymous@.discussions.microsoft.com> wrote in message
news:121d01c4de9c$b6badae0$a601280a@.phx.gbl...
> Hello,
> I have just down loaded SQL 2000 evaluation edition as I
> need to train myself up on Analyst Services however it
> does not appear on my list, can anyone help ?
>
What do you mean it doesn't appear on your list? What list are you
referring to?
You do have to run a separate install to get the Analysis services up and
running. When you do your install, you can choose pre-components, SQL
Server and then a separate item for Analysis services.
Ensure that you get the latest service packs and apply them to both the SQL
Server and the Analysis services. (SP3a is the latest for SQL Server 2000).
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||"Patricia" <anonymous@.discussions.microsoft.com> wrote in news:121d01c4de9c
$b6badae0$a601280a@.phx.gbl:
> Hello,
> I have just down loaded SQL 2000 evaluation edition as I
> need to train myself up on Analyst Services however it
> does not appear on my list, can anyone help ?
>
Analysis Services is a seperate install? I don't know if it is included in
the evaluation. Anyway. Start install, click SQL Server 2000 Components
then click Install Analysis Services. Good Luck!
Regards JTC ^..^