BPS read performance

[Former Member]

Hello colleagues!

I have some questions on performance issues

1.Can anyone explain why BPS is readinf data from infocube using sequentional, rather then direct read?all indices and statistic is up-to-date (picture frjm sm50)

4 DIA 9651 Running Yes SAPLRSDRS 400 JDOE Sequential read /BIC/FTEST

2. we have mulltiplanning area and copy data from A1 to A2

BPS reads data from A2 twice (we can see that in BPS_STAT0). First time - with "E" mode(exclusive lock), second - as ref data. But we don't use A2 area in right part of experssions! Single read is enough from our point of view. What should we do to exclude second reading?

BW 3.0B SP21, SEM 3.1B SP28

Best regards

Alex

[Former Member]

Hi Alex,

Maybe it is not relevant anymore, but I have just faced the same problem with the FOX.

It seems to me that the FOX is executed twice because it is assigned to the layout twice in the folder. For example, once as a pushbutton and once as a function to be executed before the layout is displayed.

If you assign the FOX three times with different attributes (pushbutton + before display + after change) it will be executed three times even if you click on the pushbutton only once (and of course don't do anything else).

Hope it helps,

Attila