SAP BPC NW - Performance Issue - Input schedules EPM Add-In "RefreshCaches"

[fketterer]

Dear Experts,

we're currently facing an issue for a customer, where we have some performance issues with our reports. They are pulling larger data sets with supress zero and empty values. What we found out via the "TRACE" Logs in EPM Add-In is, that there is a particular component during refresh, what I don't know about and what it's doing in detail. It's taking about 4-5 seconds, so quite much. It is called "Refresh Caches" (see Screenshot).

2019-01-29 04:26:08,572|TRACE|Performance|FPMXLClient.Office.EPMExcelWorkBookManager.RefreshCaches|KNAUBJ|||||VSTA_Main|Method [RefreshCaches] end, duration = 6.921 s#

Does anybody know about it and maybe even if this can be eliminated? In the thread here:

https://archive.sap.com/discussions/thread/3868843

There is a TRACE Log which also contains refresh caches, but it's 0 seconds.

We're using:

EPM Add-In SP23 P2 for this particular test, but SP30 P1 showed similar results.

Meta Data Cache is not activated as per user options:

Server Version: BPC NW 10.1 on BW 7.5 SP8

Let me know if any more info is needed, I hope somebody knows about that!

Best Regards,

Fabian

[former_member186338 · Accepted solution]

Sorry, but looks like you don't understand me! I am talking not about meta data, but about transactional data!

This data is saved in the input schedule object on each refresh and used when user press save button to determine changed values!

P.S. How do you suppress rows? hide or delete?

[fketterer]

Hello Vadim,

thanks for your input. In fact, switching the large background report to "no input schedule" helped bringing down the refresh time 5-6 seconds. No idea why this was defined as input template, but that's a different story.

Best Regards,

Fabian

[former_member186338]

Each report can be individually defined as "Input Form" and in this case the cache will be updated on each refresh!

If you have 2 reports and one is small and only small is "Input Form" - then cache update will be fast

[fketterer]

Hello Vadim,

we're removing the empty and zero rows, so no hiding. I will check now if we have defined the large EPM report as input sheet, because in general the sheet consists of a small input area and a large background data report.

Best Regards,

Fabian

[former_member186338]

You are talking about input schedule and refresh caches mean that local data cache has to be synchronized with server data. This is a correct behavior and can't be disabled.

[fketterer]

Hello Vadim,

thanks for your reply. In general I agree that it needs to be synchronized, but why is it taking so much time? Do you know any way to reduce the time it needs? Could this be reduced if we activate the meta data cache?

Best Regards,

Fabian