Solution : https://service.sap.com/sap/support/notes/1136163 (SAP Service marketplace login required)
Summary :
This SAP Note covers detailed documentation on optimal configuration settings for various technical query attributes, vital for proper functioning and performance of InfoProviders. SAP Notes 1022589 and 1138864 provide foundational guidelines for checking and setting default values, and describing the delta cache process, respectively. The document emphasizes proper settings for hierarchy processing, various modes (like RSRREADMODE, ACTUALDATA), and the utilization of the delta cache in order to ensure efficient data retrieval and processing across different InfoProvider features in a MultiProvider setup. It also discusses the effect of cache settings on query performance, which is crucial for maintaining system stability and performance.
Key words :
input-ready query input-ready queries play, input-ready queries, plan/actual comparison multiprovider, input-ready query, delta cache process corresponds, request status/data validity, set default values relevant, completely support read mode, precalculating web templates, leaves -> rsrhiedir_olap-readmode
Related Notes :
| 1288883 | The delta part of an InfoCube delta pair is not cached |
| 1278619 | Query displays no data or cache is not read |
| 1257455 | Exception aggregation: Performance and memory requirement |
| 1176819 | Exception CX_SY_ARITHMETIC_OVERFLOW |
| 1138864 | Delta procedure of the OLAP cache |
| 1022589 | The query settings RSRT -> Query Mass Maintenance |
| 1007722 | 0REQUID variable 0S_RQTRA, 0S_RQMRC, 0S_RQALL and ACTULDATA |