How to view MDX query from Excel report

Hot Topic

Drop all column extended propterties
IMPORT DATA FROM XML SOURCE TO SQL
matrix issues
Data Validation
Migrating SQL 2000 from a 2000 domain to 2003 domain
Creating a database on SQL server 2005
Connect to SQLExpress via Internet with Windows Authentication?
Stabilizing the Matrix Column
sql stored procedure question
Create Extended Procedures in VS 2005

SQL Server

[SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe
An existing connection was forcibly closed by the remote host
Tx replication works in 2000 but not in 2005?
programmatically extend project tree
Translating Access Cross-Tab query into T-SQL?
profiler can't save trace to file
Sql Server internal error
Excel Destination Error: Column"xx" cannot convert between unicode and non-unicode string data types
How to set the width on the multi-select drop down (not the simple select)?
A function that returns comma delimited results

How to view MDX query from Excel report

Hey guys,

I generated OLAP report from SQL Server Analysis server using Excel. When you are using Excel to generate a report from OLAP database, excel will take care of generating the required MDX query behind the scenes. That means you don't need to hand-write MDX queries yourself. So, my question is pretty simple, i.e. Is there a way to view the MDX query that is generated automatically by excel

Thank you for taking your precious time.

Sincerely,

Amde

Answer this question

How to view MDX query from Excel report

  • Ghost Assasin

    Please let me know if anyone have idea about this thing.

    sincerely,

    Amde

  • binarysins

    I really appreciate your response. Can you please tell me the step-by-step procedure to capture the MDX query generated by Excel

    Sincerely,

    Amde

  • VasudevaKumarAtukuri

    With AS 2005, you can use SQL Profiler to capture the MDX query generated by Excel:

    http://msdn2.microsoft.com/en-us/library/ms174779(SQL.90).aspx

    >>

    Introduction to Monitoring Analysis Services with SQL Server Profiler

    You can use SQL Server Profiler to monitor events generated by an instance of Microsoft SQL Server 2005 Analysis Services (SSAS). By using SQL Server Profiler, you can do the following:

    • Monitor the performance of an instance of Analysis Services.
    • Debug Multidimensional Expressions (MDX) statements.
    • Identify MDX statements that run slowly.

    >>



  • How to view MDX query from Excel report
Answer this question