Solution : https://service.sap.com/sap/support/notes/620361 (SAP Service marketplace login required)
Summary :
SAP systems experiencing prolonged loading or activation times in ODS objects due to high request volumes can implement a solution to expedite processes. For data targets submerged under large request loads, create a copied target to consolidate requests and facilitate quicker operations. Key steps include ceasing delta updates, reallocating existing data and queries, and systematically deleting old data after successfully transitioning to the new target. Additionally, optimize database statements by modifying parameters according to SAP Notes 48230 and 601612. This method also suggests monthly or weekly routine checks to ensure optimal system functionality.
Key words :
empty a1 data target, a1 data target content, change existing multiproviders, identical copy a2, key figure identifier, data target slows, affected data target, data target a1, a1 data target, a2 data target
Related Notes :
| 1431315 | P24: Reducing very large request lists in InfoCubes and DSOs |
| 892513 | Consulting: Performance: Loading data, no of pkg, req size |
| 634263 | Selects with FOR ALL ENTRIES |
| 601612 | P11: Manage: Slow formatting due to large Oracle IN list |
| 567747 | Composite note BW 3.x performance: Extraction & loading |
| 48230 | Parameters for the SELECT ... FOR ALL ENTRIES statement |