SAP BW on HANA runs differently

What is SAP HANA?

With HANA, SAP has developed a database that can process data much faster than conventional databases thanks to in-memory technology. In-memory technology no longer accesses hard disks for data retrieval, but keeps all data in memory. In this way, data can be analyzed and processed almost in real time - this speeds up business processes in the field of big data many times over. On the software side, SAP HANA uses a combination of column and row-oriented working methods. HANA was initially developed for business intelligence and business analytics applications and used in SAP Business Warehouse and Business Objects Strategic Workforce Planning. However, other SAP products and all SQL-based applications can also be operated with HANA.

What challenges does migration to SAP HANA pose for application development?

"All problems solved" mentality:

  • HANA will not improve your requirements management
  • HANA does not solve any business, conceptual or implementation-related problems
  • The processing time also increases in SAP HANA with the complexity of the task

Detailed breakdowns were seldom carried out on leisurely working databases with large amounts of data and problem cases have remained hidden


If dependencies have not been consistently taken into account in the existing ETL automation, it is advisable to re-automate the loading processes due to the greatly changed loading speed.

Migration to SAP HANA

Why application optimization should take place after the HANA migration

  • Technical: In the many applications, the last persistent data layer can be completely omitted, i.e. the application of allocated storage space is permanently reduced and the application is streamlined.
  • From a business: Migration to a HANA database usually takes place in combination with an SP upgrade. BI tool development under 7.4 is very dynamic, with numerous improvements for development and administration