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.

Getting ready

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 ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.