SAP BW on HANA is the next wave of SAP's in-memory technology vision that enables SAP NetWeaver BW to use SAP HANA as a fully functioning in-memory database. Running SAP BW on HANA results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in lower total cost of ownership.
What is SAP BW?
SAP NetWeaver Business Warehouse (SAP NetWeaver BW) or also called SAP BW in short, is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP.
Serving as a powerful Enterprise Data Warehouse application platform BW provides flexible reporting and analysis tools. It is a packaged, comprehensive business intelligence product centred on data warehouse that is optimized for the R/3 environment from SAP.
What is SAP BW on HANA?
SAP BW on HANA is nothing but SAP's existing NetWeaver BW data warehouse, running on SAP HANA. SAP now supports SAP HANA as the underlying database for the NetWeaver BW Data Warehouse. Because SAP HANA is much faster than regular relational databases like Oracle or Microsoft SQL Server, the data warehouse performs much faster. The purpose of SAP BW on HANA is to combine the power of both.
What are the drawbacks of SAP BW on a RDBMS like Oracle?
Time to change:
Any change in structure or report takes too much time. Normally it takes 3-12 months to get a change in structure or report.
Flexibility:
It lacks the granular level details. In SAP BW data is aggregated and materialized so users can't get the way they need or at the granularity they require.
Performance:
Every report has to be tuned for acceptable performance.
Real time data not available:
Real time data are not available for analysis. Data is moved to SAP BW in batches and takes time.
Comments
Post a Comment