O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required