Solution : https://service.sap.com/sap/support/notes/1903204 (SAP Service marketplace login required)
Summary :
SAP Note addresses performance issues when executing MDX statements using BW display hierarchies in SAP NetWeaver BW. The problem is identified in the CL_RSR_RRK0_PARTITION class, method HIERA_AGGR_02, leading to prolonged runtimes and high memory usage. The lack of optimization is noted, and enhancements are advised, especially in cases where only parts of the hierarchy are accessed. The recommended solution involves importing specific Support Packages across various SAP NetWeaver BW versions to incorporate necessary improvements and adjustments. Advance correction instructions are available for urgent implementations.
Key words :
subsequentsap_bw701702 711711 730730 731731 740740 correction instructions correction instructionssoftware componentvalid fromvalid tonumbersap_bw7017401653333sap_bw7017401656134 support packages & patches support packagessoftware componentreleasesupport packagesap_bw701sapkw70115702sapkw70215711sapkw71113730sapkw73011731sapkw73110740sapkw74005 references, terms ole db olap display hierarchy hiera_aggr_02 cl_rsr_rrk0_partition reason, high priority category performance validity software componentfrom rel, -odb ole db provider priority correction, customer component bw-bex-ot-mdx mdx, high main memory consumption, 4 abap sp 05 1882717 sapbwnews nw bw 7, correction instructions, sap notes 1888375 sapbwnews nw bw 7, / __%pdfstyle%__font-size
Related Notes :
| 1888375 | SAPBWNews NW BW 7.4 ABAP SP 05 |
| 1882717 | SAPBWNews NW BW 7.31 ABAP SP10 |
| 1878293 | |
| 1868060 | |
| 1142664 | MDX: Composite SAP note about performance improvements |