Home > Courses > Technical > BW HANA


167 Ratings

Course Duration : 50h

Course Level : Beginner

About the Course

SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. This functionality explores all the key features of HANA database technologies and uses BW as a modeling tool for data modeling and analytical reporting. SAP Business Warehouse (BW) powered by HANA also known as BW on HANA (BWoH) is SAP’s data modeling, warehousing,
and reporting tool built on the HANA database. SAP BW on HANA (BWoH) runs on the HANA database and therefore it is simpler and faster.


SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database.


This functionality explores all the key features of HANA database technologies and uses BW as a modeling tool for data modeling and analytical reporting.

BW software supports various databases like Oracle, Microsoft, IBM DB2, Teradata, and many more. BW on HANA suggests that you are using HANA as database for BW data modeling capabilities and no other database is required.

  • Implementing SAP BW on HANA specific modelling like Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, LSA++, etc.
  • Work on HANA Studio – Schemas and tables on HANA, attribute view, analytical view and Calculation views.
  • Developing and handling hybrid scenarios – BW data models and HANA views as per the requirement.
  • Manage SAP BW tables in HANA distribution environment.
  • Experience in integration with BW/BO/HANA is highly required.
  • Knowledge on BOBJ tools like WEBI, Lumira, and Design studio is a plus.

those having advanced level knowledge on SAP BW functions and SAP HANA Native modeling. After completing this course, you will become expertise in maintaining BW on top of HANA database, and exploring some key capabilities on BW powered by HANA.

  • Using the new BW/4HANA user interfaces that have been redesigned to support modelling data models and data flows, query building and administration.
  • Working with new modelling approaches which lean heavily towards a virtualised data warehouse and mixing SQL based data models from native HANA.
  • Using the new best practices for BW/4HANA with LSA++, instead of the old LSA.
  • Taking advantage of the staggering data integration possibilities. BW/4HANA can consume any type of data, from anywhere. You need to learn how to connect both physical and virtual data sources.

Before you start proceeding with this tutorial, we assume that you are well-versed with basic BW and HANA concepts, like DataStore Objects (DSO), Data Transformations, InfoCubes, Query optimization, HANA Modeling and HANA DB features using HANA Studio. If you are not aware of these concepts, then we recommend that you first go through our tutorials on BW and HANA.

Key Features

Instructor-Led Sessions

50 Hours of Online Live Instructor-Led Classes. Weekend Classes: 24 sessions of 2 hours each. Weekday Classes: 50 sessions of 1 hour each.

Real-Life Case Studies

Live project based on any of the selected use cases, involving implementation of the various concepts.


Each class will be followed by practical assignments.

Lifetime Access

You get lifetime access to LMS where presentations, quizzes, installation guide & class recordings.

24 X 7 Expert Support

We have 24×7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.


After completing your final course project successfully emax will provide you certificate as a SAP Trainee.


  • Introduction to BW
  • Introduction to HANA as a Platform
  • The Multi-dimensional Model in SAP BW
  • The SAP BW Star Schema Concept
  • Extended Star Schema
  • Creating data warehousing Objects
  • Info Areas
  • Info Object Catalogs
  • Info Objects-Characteristics
  • Info Objects-Key figures
  • Info Cubes
  •  Data store Object
  • Multiprovider
  • Info Set
  • Creating flat file source System
  • Creating Data sources
  • Data transfer process
  • Connecting Data sources to Info Objects (Master data)
  • Connecting data sources to Info Providers
  • Info Package
  • Data store Objects
  • Info Cubes
  • Creating Loading Structure – DTP
  • Master Data Loading
  • Attributes
  • Text
  • HierarchiesTransaction Data
  • Data Stores Object
  • Info Cubes
  • Advanced Data Store Object
  • Creating Data Flow Object
  • Copying Data flows
  • Identifying & Activating the Business content data sources
  • Configuring the data source
  • Logistics cockpit settings
  • Loading Data into setup tables
  • Checking the extractor
  • Creating Info package – in it, Delta, Full load
  • Working with requests in the Data store object and Activation
  • Introducing LSA ++ Architecture
  • Introduction to HANA Studio
  • Creating ADSO as a Cube
  • Creating ADSO as a DSO
  • Field Level Modeling
  • Composite Provider
  • Creating a union Composite Provider
  • Creating a Join Composite Provider
  • Associating fields in the Composite Provider
  • Mapping of fields in the composite Provider – Compounding, Nav Attributes
  • Creating Open Operational Data store
  • Creating BEX Query on BW info Providers – Composite Provider, ADSO, Cube
  • Conditions
  • Exceptions
  • Filters
  • Variables
  • Calculated Key figures
  • Restricted Key Figures
  • Working with the properties of Objects

Course Certification



  • You will never miss a lecture at Emax You can choose either of the option: View the recorded session of the class available in your LMS.


Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.


Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24×7 support team will be granted instantly as well. You can start learning right away.


Yes, the access to the course material will be available for lifetime once you have enrolled into the course.


Sr. SAP BW HANA Consultant
10+ Years of Experience

Upcoming Batches

Scroll to Top