Friday, 14 April 2017


SAP BW on HANA is the following stream of SAP's in-memory technology idea that permits SAP NetWeaver BW to utilize SAP HANA as a totally operating in-memory database.
Running SAP BW on HANA yields in drastically expanded execution, simplified organization and streamlined IT landscape resulting in the below complete cost of ownership.
Working as a powerful Enterprise Data Warehouse application platform BW offers extensible reporting and analysis tools. It is a packaged, comprehensive business intelligence product centered on a data warehouse that is optimized for the R/3 environment from SAP.
SAP NetWeaver Business Warehouse (SAP NetWeaver BW) or also called SAP BW in short, is the name of the analytical,  Business Intelligence, reporting, and Data Warehousing solution presented by SAP.

SAP BW Overview

SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. BW software supports different databases like Microsoft, Oracle, IBM DB2, Teradata, and so on. SAP BW on HANA proposes that you are using HANA as the database for BW data modeling abilities and no other database is needed.

What is SAP BW on HANA?

SAP BW on HANA is a SAP's existing NetWeaver BW data warehouse, running on SAP HANA. SAP now bolsters SAP HANA as the underlying database for the NetWeaver BW Data Warehouse. Since SAP HANA is substantially speedier than consistent relational databases like Oracle or Microsoft SQL Server, the data warehouse performs considerably quicker.
The motivation behind SAP BW on HANA is to consolidate the power of both.
Customer value of SAP BW on HANA:
•    Best query performance for improved decision making
•    Accelerated In-Memory planning capabilities for faster planning scenarios
•    Data persistency layers are cut off and reduced administration efforts
•    Performance increase for Data Load processes for reduced the data latency
•    Flexible - combine EDW with HANA-native data for real-time insights and decision making
•    Simplified data modeling and remodeling

BW Basics

SAP BW combines data from various sources, transforms and combines the data, stores data and performs data cleansing. SAP BW also involves administration & staging area and data modeling.
Data in SAP BW is obtained with the help of a centralized tool known as SAP Business Intelligence (BI) Administration Workbench. The BI platform presents infrastructure and functions to include −
•    OLAP Processor
•    Metadata Repository
•    Process Designer and other functions
Business Explorer (BEx) is a reporting and analysis tool that supports query, analysis, and reporting functions in BI. Using BEx, you can analyze historical and current data to a different degree of analysis.
SAP BW is identified as open, standard-based tool which enables you to extract data from various systems to BI system. It estimates the data with different reporting tools and you can share this to other systems.
When you use SAP BW on HANA, the following processes are not required −
•    Rolling Up Filled Aggregates
•    Filling of New aggregates
•    Adjust Time-Dependent Aggregates
•    Construct Database Statistics
•    Build Index
•    Delete Index

We are SAP Online Training Institute. We offer SAP BW HANA Online Training, SAP Training Chicago, SAP HANA Training Chicago etc.

Contact us:

Email id:
IND: +91 992 284 8898
USA: +1 678 389 8898
UK: +44 141 416 8898