Create Your Own SAP Standard!
Our Development and Customizing Technologies for SAP
Include comments in reporting
To achieve better transparency and traceability, our customer – a globally active insurance group – wanted to be able to add detailed comments to target figures in Excel and display these in the generated reports. However, Analysis for Office only supported short texts, and there were also performance issues. Controlling was no longer willing to work with this inadequate solution. To remedy the situation, we developed a custom solution in VBA and ABAP that allows for comments of any length that can be automatically retrieved and displayed in reporting.
From eight hours down to a few seconds
Most companies know the kind of situation our client found themselves in: Their home-grown ABAP developments within SAP BW/ERP as well as increasing data volumes resulted in ever slower data processing. At some point, not even the overnight run was enough to complete all jobs.
We streamlined the system by first performing code reviews to identify possible causes such as nested loops or database accesses. By means of performance and runtime analyses (trace), we measured the code in more detail and evaluated the aggregated results to identify weak points. We then remedied the situation by replacing and greatly simplifying the ABAP developments by means of HANA technologies in SAP BW. As a result, runtimes were accelerated significantly. For some functions, processing time was reduced from eight hours to 20 seconds.