Solution : https://service.sap.com/sap/support/notes/1599602 (SAP Service marketplace login required)
Summary :
SAP Note discusses resolving performance issues in SAP BW during data extraction from source systems. It outlines the need for proper parameter settings and adjustments in various transactions like RSCUSTV6, RSODSO_SETTINGS, and RSBATCH for optimized load, PSA, and DSO performance. For DSOs, configuring the partition sizes and disabling automatic activation during parallel loading are advised alongside setting preferred timings and process amounts in the system. Recommendations include retaining only necessary data in PSA and DSO change logs, adjusting master data delta limits, and enhancing DTP through parallel processing. Further, managing large non-BW tables and optimizing process chain performance are discussed, with links to additional SAP notes for detailed guidance.
Key words :
rsa1 -> display dtp -> goto menu -> settings, = 3 rdisp/max_wprun_time rdisp/max_wprun_time - rz11, /saphelp_nw70/helpdata/en/42/ead8d7b55e1bd2e10000000a11466f/frameset, rdisp/max_wprun_time 3600 sap common recommendations, prerequisites extraction performance problems due, psa/changelog deletion process introduced, rsodso_settings transaction optimal packet size, customer specific transformation routines, parallel processing > dtp_load > click, errors logs include loads
Related Notes :
| 1597364 | FAQ: BW-BCT: Extraction performance in source system |
| 1461926 | FAQ: BW report SAP_INFOCUBE_DESIGNS |
| 1455399 | Performance issues with DSO activation |
| 1392715 | DSO req. activation:collective perf. problem note |
| 1163359 | Load methods using SMQS or SAPI-controlled to transfer to BW |
| 590370 | Too many uncompressed request (f table partitions) |