SAP Business Warehouse (BW) powered by SAP HANA helps you speed up data analysis by consuming data via a Data Warehouse (DW) for analytical reporting and data analysis. You can achieve key opportunities like real-time data integration and data modeling, and hence real-time BI reporting on large amount of data in the database.
SAP Business Warehouse continues to act like a powerful data warehouse tool to consolidate master data and provide flexible reporting options. With SAP HANA underneath BW system as a database, you can use a combination of DW capabilities with fast in-memory database to achieve performance improvements and exceptional modeling capabilities.
HANA in-memory database is much faster as compared to other common databases like Oracle, SQL Server, and hence DW performs much faster when powered by HANA as database underneath it. It combines the power of both the tools – BW Modeling and HANA in-memory computing engine to process huge amounts of data.
BW on HANA supports various exceptional databases and reporting capabilities that are not possible using other databases – like transformations and DSOs are moved to HANA database to provide much faster processing of data, data load performance, query processing and optimization, exceptional HANA modeling capabilities, etc.