Capturing MDX queries generated by SSAS frontends
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 to use another tool that 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 add-ins to the application that generates MDX queries.
In this recipe, we're going to show how to capture the MDX query that has been sent by an application to the server using SQL Server Profiler.
In Microsoft SQL Server Management Studio for SQL Server 2016, SQL Server Profiler can be found in the Tools menu:
If after starting the Profiler a window appears offering us to select ...