Optimizing Performance During Data Loading and Bex Query Execution in SAP BW4HANA

2. Split the data loads in smaller sizes by reducing the package size in DTP and by grouping the dataset by setting Semantic Grouping

DTP filter settings: Adjust the package size depending on the data size in source.

ABAP Runtime:

1. Filter out data as much as possible in the initial run of the queries by adding filters or input variables based on business requirements.

2. Queries should be generally created on top of the Composite providers than individual infoproviders like ADSOs, Infoobjects, etc. for better performance.

3. Keep only the required characteristics in the report instead of placing the entire list in the free characteristics.

4. Active hierarchies for any master data objects can be enabled after initial query run while navigating through the report which will avoid the hierarchy processing during the initial run itself thereby increasing the performance.

5. For detailed analysis of the query performance, we can execute the query in RSRT 🡪 Execute + Debug option 🡪 select – Display statistics data 🡪 This will display the detailed analysis of the query run.

6. Push the complex calculations to the transformation layer rather than calculating in the query runtime.

7. For the individual characteristics in the Query structure or free characteristics, set Result rows option to Always suppress 🡪 this will avoid calculation of key figure cumulation during report slice and dice.

8. Select proper decimal precision for key figures.

9. For queries which doesn’t have a sub query or formula variable with replacement path that executes another query 🡪 deactivate parallel processing (RSRT 🡪 Execute + Debug mode 🡪 Data Manager 🡪 select no parallel processing)