Challenge
It was planned to migrate BW, which had grown over many years, to BW on HANA. In this process, the existing models were to be optimised and the data flows were to be streamlined and, if necessary, rebuilt.
Facts about the customer
Industry: Energy and water supply
Company size: Large regional company
Solution
In the course of several workshops, the exact requirements were recorded, the sizing of the system was carried out and the legacy system was also cleaned up through corresponding housekeeping tasks. After the actual database migration, the HANA data flows were optimised, coding was pushed into HANA and data redundancies were significantly reduced.
Customer benefit
The client now has a much leaner data warehouse that provides superior reporting and loading performance. Additionally, the total data volume or information losses could be reduced, and the complexity of the data flows could be eliminated. This makes future enhancements easier and faster, while maintaining the same reporting performance.
