Solution : https://service.sap.com/sap/support/notes/1522691 (SAP Service marketplace login required)
Summary :
Updating SIDs in SAP BW may face performance issues due to database limits impacted by Statement Length and/or Bind Variables. A performance enhancement has been designed where SIDs for Infoobjects are materialized in temporary tables instead of using IN-lists. This switch to a more efficient method occurs when updates exceed a threshold of 250 SIDs, customizable through SPRO settings under NetWeaver > BI > Performance Settings. The RSADMIN parameter RRSI_MASS_UPDATE controls whether this update method is active ('Y' for enabled). Support Package 02 for SAP NetWeaver BW 7.30 must be imported following guidelines in SAP Note 1506833 to implement these changes.
Key words :
sap netweaver -> business intelligence -> performance settings -> optimize sid generation, standard sap customizing transaction - spro, solution sap netweaver bw 7, sap netweaver bw 7, sid determination process, check sap note 875986, sid flags update, sid flag update, 30 bw abap sp02, database limits related
Related Notes :
| 1552741 | Performance Optimization :SID Flag Updates - Follow-up Note |
| 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 |