Question Re: SQL Query in Financial Management Q&A

SQL Query

oscarforeman — Tue, 27 Oct 2015 14:45:21 GMT

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.

Re: SQL Query

Former Member — Wed, 28 Oct 2015 09:28:11 GMT

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

Re: SQL Query

oscarforeman — Wed, 28 Oct 2015 17:24:48 GMT

This information is related to Logs not SQL query information. We are using SQL Profiler but the query seems incomplete.

Re: SQL Query

JohnL — Wed, 28 Oct 2015 17:48:26 GMT

Hi Oscar,

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

Thanks,

Re: SQL Query

oscarforeman — Wed, 28 Oct 2015 18:17:46 GMT

Majority is base level members and 1 property field

Re: SQL Query

JohnL — Wed, 28 Oct 2015 18:28:42 GMT

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