Solution : https://service.sap.com/sap/support/notes/482494 (SAP Service marketplace login required)
Summary :
Loading data from liveCache to an InfoCube in SAP APO requires optimization due to performance lags noted specifically with SNPs and DPs. Performance improvements have been achieved in updates detailed through various Support Package enhancements and SAP Notes, which target loading speeds and aggregation methods. To enhance data extraction rates, utilizing separate InfoSources for liveCache and InfoCubes, adjusting parameters in ROIDOCPRMS, and setting optimal package sizes through /SAPAPO/TS_PAREA_EXTR_SETTING are recommended. Parallel processing and optimized read routines from newer Support Packages reduce lock issues and accelerate data handling, particularly noticeable from SP 17 onwards. Avoid PSA buffering and don't use ODS to enhance insertion speeds into data targets.
Key words :
respective infocube --> 'manage' --> tab title 'performance' --> 'build index' --> set, read routine solves sporadically occurring livecache locking problems, optimized read routine requires, import apo support package 17, lower support package level, package size dependencies relating, define special package sizes, snp / aggregate 9amalothe process, optimized read routine, snp / aggregate 9amalorejuly 05
Related Notes :
| 1547072 | Memory and performance problems during data extraction |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 549184 | FAQ: What is important for extraction |
| 540571 | Collective consulting note on data extraction in DP |
| 515120 | Performance of the extraction of InfoCube-based key figures |
| 500843 | Composite SAP note for COM and SAP liveCache 7.2 or higher |
| 417307 | Extractor package size: Collective note for applications |
| 409641 | Examples of packet size dependency on ROIDOCPRMS |
| 157652 | Main memory requirement for extraction from R/3 |
| 130253 | General tips on uploading transaction data to BW |