http://prologika.com/CS/blogs/blog/archive/2009/07/06/how-to-test-ssrs-mdx-queries-in-sql-server-management-studio.aspxI often need to capture an MDX query that a report sends to Analysis Services and execute it in SQL Server Management Studio (SSMS). I usually do this to understand what parameters the report passes to the query and to troubleshoot the query itself. UnfortunatelyenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://prologika.com/CS/blogs/blog/archive/2009/07/06/how-to-test-ssrs-mdx-queries-in-sql-server-management-studio.aspx#3504Tue, 07 Jul 2009 00:02:48 GMTbb61d221-b363-4d22-8192-4aa25b39c5db:3504Teo Lachev<p>Yes, indeed. I updated the blog. Thanks Greg!.</p> <div style="clear:both;"></div><img src="http://prologika.com/CS/aggbug.aspx?PostID=3504" width="1" height="1">http://prologika.com/CS/blogs/blog/archive/2009/07/06/how-to-test-ssrs-mdx-queries-in-sql-server-management-studio.aspx#3501Mon, 06 Jul 2009 14:50:43 GMTbb61d221-b363-4d22-8192-4aa25b39c5db:3501furmangg<p>Darren Gosbell has got a utility which does a lot of the grunt work for you:</p> <p><a rel="nofollow" target="_new" href="http://geekswithblogs.net/darrengosbell/archive/2007/07/04/SSAS-Exporting-MDX-from-Profiler-part-2.aspx">geekswithblogs.net/.../SSAS-Exporting-MDX-from-Profiler-part-2.aspx</a></p> <div style="clear:both;"></div><img src="http://prologika.com/CS/aggbug.aspx?PostID=3501" width="1" height="1">