Hawesko (Hanseatic Wine and Sect Kontor) Holding AG combines online sales and stationary trade for wine and sparkling wine. Acquisitions and disposals form an agile group structure. In addition, heterogeneous ERP systems and asynchronous data flows resulted in a high manual workload. Ad hoc queries were therefore not only time-consuming, but also only feasible to a limited extent.
Hawesko Holding AG set itself the goal of making group reporting more transparent and faster. The optimizations were intended to facilitate the preparation of financial statements through automation.
Mission
Harmonization of reporting data and replacement of the existing DWH.
Integrated solution approach for consolidation and for group reporting, taking into account optimised processes
Implementation of the solution approach and development of the IT landscape by an agile team (SCRUM methodology)
Solution
Establishment of a central data warehouse
Automation of the reporting system of the subsidiaries
System-supported commenting functionality
Mobile reporting
Services and used Technologies
Agile project implementation; increments are built, tested and approved according to the highest benefit of the stakeholders.
SAP Business Warehouse powered by SAP HANA (Data Warehouse Technologie)
SAP BusinessObjects BI Platfom 4.2 (environment for collaboration and the provision of reporting and planning applications)
SAP BusinessObjects Analysis for Microsoft Office (frontend for the use of the applications)
Results
Technical connection of all locations (at home and abroad)
Daily actual figures
Increasing the quality and enrichment of reporting data
