Saturday, May 26, 2018

What is SAP BW on HANA 

SAP Business Warehouse (BW) controlled by SAP HANA refers to utilizing BW programming suite over HANA database. This usefulness investigates all the key elements of HANA database advances and influences utilization of BW as a displaying to apparatus for data demonstrating and logical announcing. BW programming bolsters various databases like Oracle, Microsoft, IBM DB2, Teradata, and a lot of something beyond. BW on HANA demonstrates that you are utilizing HANA as a database for BW information displaying capacities and no other database is required. 

SAP BW on HANA Overview
SAP BW on HANA Overview

SAP Business Warehouse (BW) controlled by SAP HANA encourages you to accelerate information examination with the guide of devouring information through a Data Warehouse (DW) for expository announcing and data assessment. You may accomplish key open doors like continuous records mix and information demonstrating and subsequently, ongoing BI giving an account of the colossal measure of realities in the database. 

What is SAP BW on HANA BW Basics? 

SAP BW combines data from different origins, changes, and bonds to the information offer data cleansing and stores information. SAP BW additionally includes data modeling, administration and staging zone.

Information in SAP BW is finished with the support of an incorporated design known as SAP Business Intelligence (BI) Administration Workbench. The BI stage gives foundation and capacities to incorporate − 
  • OLAP Processor 
  • Metadata Repository 
  • Process Designer and different capacities 


Business Explorer (BEx) is an reporting and investigation device that backings inquiry, examination, and revealing capacities in BI. Utilizing BEx, you can break down authentic and current information to the various level of investigation. 

SAP BW is known as open, standards-based tool which enables you to separate information from various frameworks to BI framework. It assesses the information with various detailing instruments and you can convey this to different frameworks. 

Disadvantages of utilizing SAP BW with different Databases

Real-time Reporting − Applying BW with a few databases, you can't do ongoing detailing as constant information isn't accessible in the information distribution center. Information is moved to business Warehouse in bunches and hence isn't accessible for ongoing detailing. 

Actualizing Structural changes − To implement any structure alterations, it is exceptionally tedious and an intense venture as the similarity isn't accessible with various DB suppliers. To authorize any structure adjustments in business Warehouse, it takes 2 a year. 

Report Execution − You need to perform report execution advancement and tuning for each product. 

Similarity − Certainties in business Warehouse is accumulated and appeared and you may get the insights at selective granularity level. HANA helps totals at the fly when the report is performed. 

As expressed, HANA is parceling faster when contrasted with various databases like Oracle and SQL. Server. In this manner, while you consolidate HANA capacities with BW, you get fabulous records handling and detailing capacities.


SAPVITS is recognized as best SAP training institute in India and overseas. We also provide SAP server access, SAP corporate training, and SAP offshore support. SAPVITS brings to you its knowledge and expertise of over 18+ years’ in SAP online training and SAP consultancy. We mainly concentrate on SAP Training in Mumbai, Pune, Chennai, Delhi, Hyderabad, Bangalore, and Noida, India, New York, USA, London, UK, Dubai, UAE, Singapore, Malaysia, Saudi Arabia etc. We provide SAP courses like-

For more videos subscribe our YouTube channel- Vintage IT Solutions

Contact us:

Vintage IT Solutions
Email ID:
IND: +91 992 284 8898
USA: +1 678 389 8898
UK: +44 141 416 8898