Some tools allow you to write your own MDX queries, others generate them for you. If you want to know what these other MDX queries look like, you need another tool which will tell you that. One such tool is the SQL Server Profiler which comes as a part of the SQL Server installation. Others might come as an add-in to the application that generates MDX queries. In other words, there's always a way.
In this recipe we're going to show how to capture the MDX query that has been sent by an application to the server.
SQL Server Profiler can be found in the Performance Tools folder of the Microsoft SQL Server 2008 R2 folder in the list of programs available on your computer.
Start the Profiler, ...