View MDX query generated while browsing a cube in SSMS

sql sql-server ssas mdx cubes
stackoverflowuser picture stackoverflowuser · Jul 23, 2010 · Viewed 20.5k times · Source

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.

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

Thanks.

Answer

bobs picture bobs · Jul 23, 2010

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.

Related questions

OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio. I create one project of Business Intelligence Project I create a Data Source Of Adventure Work 2008 DW and then i create one Data Source View and then i …

Read More
DateAdd Column caused an overflow

After executing the following query I am getting an error Adding a value to a 'datetime' column caused an overflow. I have no idea why this is happening as it worked smoothly for a couple of weeks. I am just …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More