Skip to Content

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 28, 2015 at 05:48 PM


    Hi Oscar,

    Is the report referencing all base level members (child dimension members) vs. parent/rollup dimension members?

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 28, 2015 at 09:28 AM

    Hi Oscar,

    try following the notes about performances and troubleshootings, the first for evdre and the second for epm add-in 1851261 - Troubleshooting BPC MS EvDRE Reports and 1681762 - EPM Add-in: Where are the EPM Add-in log files stored?

    Regards

         Roberto

    Add comment
    10|10000 characters needed characters exceeded