Solution : https://service.sap.com/sap/support/notes/1714492 (SAP Service marketplace login required)
Summary :
In SAP NetWeaver BW 7.30 and 7.31, users may experience data inconsistencies and lock situations when executing queries involving multiple hierarchies or PartProviders in a MultiCube. The issues stem from the management of temporary hierarchy tables, particularly the reissue of table names in RSDD_TMPNM_AADM and buffering in RSDRHLRUBUFFER. A missing COMMIT operation after creating a new temporary table leads to reuse of table names, complicating SQL statements across different hierarchies. Resolution involves importing specific Support Packages (SAPKW73009 for BW 7.30 and SAPKW73105 for BW 7.31) and implementing advance corrections if urgent.
Key words :
problems includes incorrect data, solution sap netweaver bw 7, sap netweaver bw 7, sap notes mentioned, sap nw bw 7, 30 bw abap sp9, temporary hierarchy tables, read sap note 875986, sapbwnews nw bw 7, 30import support package 9
Related Notes :
| 1769670 | Important Notes for SAP BW powered by HANA on SP8 |
| 1755061 | MDX: Incorrect data when using external hierarchies |
| 1753103 | |
| 1750249 | |
| 1744077 | BW lock problems for simultaneous queries with hierarchies |
| 1712334 | Important Notes for SAP BW powered by HANA on SP7 |
| 1680996 | |
| 1665768 | SAPBWNews NW BW 7.01 ABAP SP12 |
| 1658505 | SAPBWNews NW7.0 BW ABAP SP29 |
| 1156101 | MDX: Composite SAP note for incorrect data |