Solution : https://service.sap.com/sap/support/notes/884482 (SAP Service marketplace login required)
Summary :
When executing queries involving multiple formulas in SAP BW systems, performance issues arise primarily in the 'loc_rechnen' form, increasing overall runtime. The discussed SAP Note identifies this inefficiency and outlines the modifications within various Support Packages to address the issue for different BW releases: BW 3.0B, BW 3.10 Content, and BW 3.50. Users are directed to import the relevant Support Package (BW 3.0B-Patch 29, BW 3.10-Patch 23, or BW 3.50-Patch 15) to their system. Additionally, preliminary versions of these notes might be available, providing early access to these improvements prior to the formal release of the packages. These notes also adjust certain condition checks ('IFs') in the formulas to enhance query execution performance.
Key words :
sapbwnews bw support package 15 netweaver'04 stack 15, 10 content import support package 23, 0b import support package 29, 50 import support package 15, 1 content support package 23, olap runtime reason, 0b support package 29, sapbwnews bw 3, support package, sapbwnews bw3
Related Notes :
| 872904 | Query runtime with many nested formulas |
| 836440 | SAPBWNews BW Support Package 15 NW'04 Stack 15 RIN |
| 825396 | Performance in reports with many selections |
| 783253 | SAPBWNews BW 3.1 Content Support Package 23 |
| 783251 | SAPBWNews BW 3.0B Support Package 29 |