DEVELOPMENT OF AN ENTERPRISE DATA WAREHOUSE
Autoneum is the world’s leading automotive supplier for acoustic and thermal management in vehicles: The global BI project emerged with the introduction of SAP R3 and the resulting global and cross-functional reporting requirements. The choices were SAP BW, Oracle and Microsoft. After a fundamental evaluation with the participation of the CFO, Finance & Controlling, HR, IT and Purchasing departments, it was decided to meet the requirements with a global Microsoft Enterprise Datawarehouse and generally with Microsoft BI from a corporate strategy point of view.
«I see the great benefit of IBCS in the standardisation and harmonisation of our board and management reporting throughout Autoneum Holding.
The number of reports and thus also the creation time has been reduced by 50%.»
Roger Sturzenegger, Head Global MDM & BI autoneum
The solution at a glance
Under these premises, the goals for our global BI project were also largely clear. One of the goals was to provide a standardised, interactive and consistent BI reporting and self-service BI tool landscape, globally and based on Microsoft. The main aim is to be able to evaluate data from different functions and across the board. As a result, the first step was to load data from accounting, consolidation, cost accounting and production into the Enterprise Data Warehouse (E-DWH). Based on this, a centralised OLAP datamart was created for power users and ad-hoc evaluations. Further datamarts are derived from the E-DWH for special requirements. Thus, the «single point of truth» approach is always maintained.
The introduction and implementation of the International Business Communication Standards (IBCS) in board and management reporting was a priority objective. «Focus on what really matters» – Conceptional, perceptual und semantic rules characterise the entire reporting system. Essential here is the support for colour and notation concepts as well as the standardisation of graphic representations.
«There are three success factors for automotive suppliers: You have to be globally positioned to be in the bidding process. Our main markets are North America, Europe and Asia. You have to be innovative to be considered for the tenders. And they would have to have cost leadership so that the margins remain attractive.»
Martin Hirzel, CEO autoneum