Solution : https://service.sap.com/sap/support/notes/1022589 (SAP Service marketplace login required)
Summary :
This SAP Note addresses settings inheritance for InfoProviders and their effects on query performance in SAP systems. It outlines how to configure InfoProvider attributes in RSDIPROP and handle query settings in RSRT, emphasizing the impact of such settings on query execution and system memory utilization. The note recommends implementing related Notes 1136736 and 1145975 for optimal settings adjustment and details steps using RSDIPROP and RSRT to ensure standardized, efficient query operations. Additional guidance includes resetting attributes using RSR_INIT_DTA_DELTACACHE and managing mass query settings adjustments, stressing careful testing before changes are applied to production environments.
Key words :
changing query attributes significantly influences query processing, main memory requirements depends, environment -> query mass maintenance, changing previous settings infoprovider, sp grouping reason, optimal setting depends, data medium exchange, reset default values, relevant infoprovider class, query attributes
Related Notes :
| 1145975 | READMODE initial leads to READMODE = A for MultiProviders |
| 1138864 | Delta procedure of the OLAP cache |
| 1136163 | The query settings in RSRT -> Attributes |
| 1112519 | Inaccuracies in OLAP cache |