Skip to Content
0
Apr 18, 2014 at 10:40 AM

BPC 10.0 Input Schedule refresh : investigating performance issues on frontend side

119 Views

Hello,

We are running SAP BPC NW 10.0 SPS8.

We recieve a lot of complaints regarding performance issues.

More specifically BPC Input Schedule refresh takes ages (11 minutes actually)

I am a SAP Basis Administartor with some solid BW experience, but very linited BPC knowledge.

So raf we have tried the following :

* BPC Full and light ptmimize of the BPC Cubes.

* Updating Oracle Statistics

* Activating ABAP/SQL traces*

* Checking USJTAT Logs

Then it rutned out that the perfromance problems werre not caused by the backend SAP BW server (only 9 seconds of bakend processing are displayed in UJSTAT).

The overwhelming majority of the processing is spent on the frontend side : on the computer of the user.

We really would like to know what is happening on BPC Frontend side, but are really lacking any investigative method .....

other that checking memory/CPU usage o nthe frontend computer.

From your experience, is there any tool/method to allow to conduct some investigation on what is going on the frontend side, when a BPC Input Schedule is refreshed ?

Thank you for your attention.