查看在SSMS中浏览多维数据集时生成的MDX查询 [英] View MDX query generated while browsing a cube in SSMS

问题描述

在Sql Server Management Studio中，一旦我浏览了多维数据集，便可以删除列字段，行字段和过滤器字段.这将显示所需的数据.

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data.

我想知道是否有办法查看幕后生成的MDX查询以显示数据吗?

I want to know if there is a way to view the MDX query being generated behind the scenes to display the data?

谢谢.

推荐答案

SQL Server Profiler可在SSAS服务器上使用.启动Profiler连接时，在连接"对话框中为服务器"类型选择Analysis Services.选择您的Analysis Services服务器并连接.您可以使用Standard Profiler模板并开始跟踪.您应该能够以这种方式查看MDX查询.

SQL Server Profiler works on SSAS servers. Select Analysis Services for the Server type in the Connection dialog when initiating a Profiler connection. Select your Analysis Services server and connect. You can use the Standard Profiler template and start the trace. You should be able to see the MDX query that way.

这篇关于查看在SSMS中浏览多维数据集时生成的MDX查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！