on ‎2006 May 06 10:28 AM
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
Request clarification before answering.
Hi alex,
the BPS cubes doesnt have the same indices as the basic cube...
check the following link
http://help.sap.com/saphelp_nw2004s/helpdata/en/39/100c38e15711d4b2d90050da4c74dc/frameset.htm
regards,
ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.