O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by 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 front-ends

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.

Getting ready

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

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