Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Query

I have a Report that I run using the Excel add-in with SAP BPC MS 10.0.  I am trying to capture the SQL query that the report is generating when it runs.  I am unable to capture the report using SQL Profiler.  I am open to suggestions on how to capture the SQL query being generated when I refresh the report.

replied

If there is at least one parent/rollup dim member then the MDX engine is used (no SQL).

You'll need to run a profiler trace for Analysis Services. When you connect in SQL profiler, choose the different engine in the drop-down

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question