BPC Report performance problem: How to debug Remote Calls

[AlpAltinturk]

Hello there,

I have the same problem as in these questions (bad performance), but the cause seems to be a different function in EPM addin, on my case: AxisQueryStreamEx & remote call:

• Small BPC 10.0 Report takes up to 4 minutes to refresh
• (Q from 2017, cause FPMXLClient.Office.ExcelReportWriter.WriteSmart)

• EPM reporting running incredibly slowly
• (Q from 2016, cause FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteReportAsGzipStream)

A simple report takes too much time to load: on Server side there seems to be no problem (it seems to be acceptably fast)

a part of EPM Add-in log is as follows:

(date 2019-05-27)
11:06:58,812|TRACE|Performance|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.AxisQueryStreamEx|USERNAME|||||1|Method [AxisQueryStreamEx] start, parameters:(..)

11:06:58,812|DEBUG|Performance|?.?|USERNAME|||||1|Remote call [http://<SERVERURL>:8000/sap/bpc/query/<APPNAME>?method=axis] start#

11:07:46,061|DEBUG|Performance|?.?|USERNAME|||||1|Remote call [http://<SERVERURL>:8000/sap/bpc/query/<APPNAME>?method=axis] end, duration = 47.249 s#

11:07:46,061|TRACE|Performance|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.AxisQueryStreamEx|USERNAME|||||1|Method [AxisQueryStreamEx] end, duration = 47.249 s#

How can I debug the remote call (or if I can do it at all) - Do you have any ideas on how to tackle this issue?

Thanks in advance!

[former_member186338]

Can you show report screenshot and provide some info about the model?

Also you need to create simplified report sample with the issue presented.

[former_member186338]

Please read

https://blogs.sap.com/2013/07/09/performance-analysis-and-optimization-for-bpc-10/

[AlpAltinturk]

I've seen this, but it seems I must read this line by line. It might help pinpoint where our issues are. Let me take a look.

Thanks Vadim!

[former_member186338]

alp.altinturk

To my mind it's better to start with report itself!

[AlpAltinturk]

the report is something like this - no expansions (all rows static), columns are connected to variables (see the green part in the image below). Not a complex input form/or anything out of ordinary.

here's a simple blueprint, to give an idea

<image001>

I'll write here anyway if i find a concrete result. Thank you!

[former_member186338]

alp.altinturk

Sorry, but nothing is visible (low resolution)!

And there is no explanation...

I am unable to help you with this info!

[AlpAltinturk]

vadim.kalinin I blurred out some of the info, next time i will create a sample case and give proper details as it should've been from the beginning. Thank you!