Solution : https://service.sap.com/sap/support/notes/1479836 (SAP Service marketplace login required)
Summary :
Using the MDX "Generate" function in SAP NetWeaver BW can lead to high runtime and memory consumption due to a program error that causes the system to read all hierarchy levels despite the restriction to a few levels. The correct data is filtered post-execution, maintaining the accuracy but at the expense of performance. Implementing the recommended correction will limit the hierarchy reading to necessary nodes when only one tuple exists in the first set, effectively reducing resource requirements. However, for cases where multiple tuples or crossjoins are involved, optimization is not feasible. Support packages addressing this issue are detailed for different versions of SAP NetWeaver BW.
Key words :
experience long runtimes, high memory consumption, main memory consumption, increase significantly depending, sap netweaver bw 7, sap nw bw 7, sapbinews nw bi 7, 01 bw abap sp08, 00import support package 25, import support package 08
Related Notes :
| 1471463 | SAPBWNews NW BW 7.01 ABAP SP08 |
| 1468668 | SAPBWNews NW7.0 BW ABAP Support Package 25 |
| 1450990 | SAPBWNews NW BW 7.02 ABAP SP05 |
| 1392433 | SAPBINews NW7.11 BW ABAP Support Package 05 |
| 1142664 | MDX: Composite SAP note about performance improvements |