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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
