Solution : https://service.sap.com/sap/support/notes/1515687 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance improvements and reduction in data transfer during MPP-optimized DSO data activation by altering the distribution key configuration. The proposed solution involves changing the distribution key from the RECORD column to the semantic key columns of the DSO, thus allowing a collocated join and minimizing data redistribution across partitions. Implementation steps include setting the RSADMIN parameter DB6_DSO_TABLES_COLLOCATED to YES, ensuring the DSO activation queue tables are empty, and reactivating the DSOs. This reconfiguration aims to enhance activation process efficiency and is applicable from SAP NetWeaver BW 7.30 with Support Package SAPKW73002.
Key words :
terms dpf distribution hash partitioning mpp sql join reason, column record primary key index ~0 defined, mpp-optimized dso data activation, mpp-optimized data activation, -unique index ~sdr defined, dso semantic key columns, activation queue table afteryou, set rsadmin parameter db6_dso_tables_collocated, primary key index ~0, distribution key defined
Related Notes :
| 1510976 | SAPBWNews NW BW 7.11 ABAP SP07 |
| 1510974 | SAPBWNews NW BW 7.02 ABAP SP07 |
| 1506833 | SAPBWNews NW BW 7.30 ABAP SP02 |
| 1471463 | SAPBWNews NW BW 7.01 ABAP SP08 |
| 1468668 | SAPBWNews NW7.0 BW ABAP Support Package 25 |