Great SSAS for Excel find

I love using Excel 2007 for analysis. But I find it limiting in terms of features. Also I like to know a little about what is going on under the hood.

So, If you want to view MDX that is generated from you modifying various pivot field there is a software that can do just that. Its called PTPower.

I also allows you to add your own calculated members :)