Capturing The MDX Generated By Reports

Debugging Reporting Services reports that include dynamically generated MDX statements can be a tedious business - however help is at hand. MVP Darren Gosbell has created a simple utility that allows you to capture the MDX generated by a report (or anything else for that matter) including all the substituted parameter values. The MDX is captured to a text file which can then be opened up for debugging in SQL Server Management Studio, or the often more useful (and free) MDX Studio.

Darren's original post about this is here, and the QueryCapture utility files can be downloaded here.