Consulting in a Box
Performance optimisation for SAP BW
With this consulting service, our experienced consultants take a close look at your SAP Business Warehouse and analyse it for weaknesses.
Performance optimisation for SAP BW
Better performance through optimised data models and BW queries - this is not a matter of course, even with the SAP HANA in-memory database. With this "Consulting in a Box" offer, our experienced consultants take a close look at your SAP BW on HANA or SAP BW/4HANA data models with regard to reporting (BW queries) and analyse them for weak points in terms of long-runners, expensive SQL statements, DB accesses, data growth, misconfiguration, etc. We analyse both the BW queries and the associated data models. In addition, we coordinate measures and procedures for optimisation with you in order to achieve the best possible results.
Your benefit
-
Performance
More performance and flexibility for your SAP BW system landscape
-
Efficiency
Stable data models with efficient runtimes
-
Stability
Improved availability of your reporting
-
Expertise
Our consultants have many years of project experience
-
Savings
By optimizing expensive SQL statements, you save hardware and valuable time.
Roadmap
Your benefit
- Analysing the most frequently used queries
- Measuring the performance of the queries
- Analysing the data models
- Reviewing the relevant system parameters for SAP BW
- Creating a rough concept and handing over the documentation
- Reviewing the results after implementing the recommendations
Objective
- Performance analysis of the 3 most important queries
- Review of specific recommendations for SAP BW from central SAP Notes and SAP Early Watch Alert Report
- Recommendations for specific parameter settings (e.g. table RSADMIN)
- Recommendations for query and data model optimisations
- Schedule and dependencies of the optimisations