SSAS 2008 Reporting Actions: MDX vs. SQL

Just a few days before the BI Summit at Microsoft (04/07/2009, Minneapolis), I was asked to explore some less known features of the Analysis Services 2008 to dig out some interesting stuff to present about. The choice was made to play with Actions, since it is still remains a grey area for many people including BI developers and Business Analysts. The idea was to write two similar Reporting Services reports utilizing MDX and T-SQL respectfully and call them as SSAS Actions from any front-end, provided that front-end supports this integration feature.