Insurance companies

Global reporting based on SAP HANA Native and BW on HANA

The client is one of the world’s leading reinsurance companies and is based in Germany. The Company’s shares are listed on all German stock exchanges and in electronic Xetra trading. Of the more than 40,000 Group employees, around 12,000 work in reinsurance.

The initial situation

  • The existing SAP BW solution no longer met the requirements.
  • Due to very long ETL times, the required data was not available in time.
  • Fragmented data models led to inconsistent reporting.
  • Extensions could only be carried out with great effort.
  • The very large amounts of data (> 3 billion records) led to complex transformations.

The solution

  • Introducing a hybrid solution to combine the best of both worlds: SAP HANA Native and SAP BW 7.5 on SAP HANA
  • Data extraction in HANA Native; persistence management and control of ETL processes in BW; virtual multidimensional data model in HANA Native; reporting in BW.
  • Implementation of a common data model across all areas
  • Ensuring consistent critical KPIs across the enterprise

The success

  • The initial data loading could be reduced from 3 weeks to 3 days.
  • Delta loads could be reduced from more than eight hours to less than one hour.
  • Thanks to the new data modeling options, it was possible to implement a uniform data model for all company divisions – One Single Truth in Reporting

In addition to the time savings and the standardization of all relevant data, the customer achieved a completely new level of transparency with regard to the cost-effectiveness and feasibility of system expansions. [Hajo Werner, Partner in Business Intelligence, entero AG]