KITS Online Training Institute is one of the best training institute in leading IT online training. We provide best SAP BW on Hana online training with our highly professional real time trainers. 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 lowering total cost of ownership. KITS  also do corporate training and help them to train their employees. We also provide other related courses.

SAP BW On HANA Online Training Course Content

Unit 1: Introduction

  • Evolution of HANA Landscape
  • SAP HANA Basics
  • SAP NetWeaver BW 4

Unit 2: SAP HANA and Business Strategy

  • Identifying Transformational Opportunities
  • Understanding Your Needs, Enterprise Needs, Data Needs
  • Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA
  • Does SAP HANA Replace BWA?
  • Pros and Cons of BWA
  • Pros and Cons of SAP HANA

Unit 3: HANA-optimized DataStore Object and InfoCube

  • HANA-Optimized DataStore Object
  • HANA-Optimized InfoCube
  • Semantically Partitioned Object
  • Unit 4: SAP HANA modeling
  • Purpose of Information Modeler
  • Levels ofModeling in SAP HANA
  • Attribute Views
  • Analytic Views
  • Calculation Views
  • Export & Import

Unit 5: MODELING of SAP BW 7.4 with SAP HANA

  • Models in SAP BW 4
  • Data Extraction and Data Flow within SAP BW 4 NW 2004S
  • New Data source Concept of BW 4
  • Transformation in BW 4(ETL)
  • DTP (Data TransferProcess)
  • FROM X TO BW 7.4
  • Business Content UPGRADING DATAFLOWS
  • Administration of InfoCubes and Aggregates
  • Virtual Cubes and Multi Providers

Unit 6: Consuming HANA Models in BW

  • Virtual Provider
  • Transient Provider
  • Composite Provider
  • DB Connect
  • Importing SAP BW models in SAP HANA
  • Importing HANA optimize infocubes
  • Importing HANA optimize DSO Unit 7: DATA EXTRACTIONS (ETL)
  • ECC Extractions Using BI BW 4 Dataflow
  • Overview of 0 Extractions.
  • Generic Extractions
  • Business Content Extractions
  • Introduction to BI Enterprise Reporting
  • Navigating in Reports
  • First Steps in Query Designer
  • Key Figures
  • Attributes
  • Exceptions and Conditions Unit 09: Transporting Objects (CTO)


UNIT 1: Hybrid provider

UNIT 2: Generic delta functionalities for further types of Data Sources

UNIT 3: Hierarchies

UNIT 4:Data Transfer Process (DTP)

  UNIT 5: Open Hub Service

UNIT 6: Transformation

UNIT 7: SAP BODS (New ETL Tool of SAP) Integration


Topics Covered MODELING

Unit 1: The Multi-dimensional Model in SAP BW

  • The SAP BW Star Schema Concept
  • Data warehousing Workbench (DWB)
  • Info Objects
  • Info Cubes

Unit2:DataExtractionand DataFlowwithinSAPBW7.4 NW 2004S

  • x Dataflow
  • Overview of BW 4 Dataflow
  • Comparison of x and BW 7.34 Data flows
  • Loading Master Data(Attributes, Texts, Hierarchies)
  • Loading Transaction Data

Unit 3: New Data source Concept of BW 7.4

  • Overview of new Datasource
  • Emulation of Data source in BW 4
  • Datasource Lifecycle with In BW 4 NW 2004S
  • Migration of x data source to BW 7.4 data source

Unit 4: Transformation in BW 7.4(ETL)

  • Transformation

Unit 5: DTP (Data Transfer Process)

  • Overview of DTPS
  • Trouble shooting techniques in DTPS
  • Debugging ABAP routines Using DTPS


Unit 7: Business Content

  • Business Content (BCT)

Unit 8: Administration of InfoCubes and Aggregates

  • Managing Basic Cubes
  • Aggregates


  • Data Store Objects concept

Unit 10: Virtual Cubes and Multi Providers

  • Virtual Cubes
  • Multi Providers
  • ECC extractions using BW 4 Data flows



Unit 1: Overview of ECC6.0 Extractions

  • Types of ECC extractions

Unit 2: Generic Extractions.

  • Generic Extraction using
  • Database Table
  • View
  • Classical Info
  • Functional

Unit 3: Business Content Extractions

  • Overview of Business Content
  • Examples from Financial, Logistics, HRMS


  Unit 5: LO-COCK PIT Extractions (LOGISTICS)

Unit 7: Delta Management

Unit 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)

Unit 9: Datasource Enhancement

Unit 10: Process Chains in Detail covering all process Types

  • Realtimeexamplesonprocess Chains(Meta Chains)

Unit 1: Introduction to BI Enterprise Reporting.

  • The SAP BIOverview

Unit 2: Navigating in Reports

Unit 3: First Steps in Query Designer

  • Query Designer
  • Info providers in query Designer

Unit 4: Key Figures

  • Restricted Key Figures
  • Calculated Key Figures
  • Properties of Key Figures


  • Properties and Attributes of Characteristics

Unit 6: Exceptions and Conditions.

  • Exceptions
  • Conditions

Unit 7: Bex Analyzer

Unit 8: Transporting Objects (CTO)


UNIT 1: Hybrid provider

UNIT 2: New monitors in BW Administration cockpit

UNIT 3: Generic delta functionalities for further types of Data Sources

UNIT 4: Hierarchies

  • Integration of hierarchies into process flow (DTP, Transformation)
  • Remote hierarchies for direct access to hierarchies in the source system
  • Loading hierarchies from flat file using the new Data Source and Transformation technology

UNIT 5: Data Transfer Process (DTP)

  • Data Transfer Process supports data extraction from Multi Providers
  • Optiontoonlyloadthelastrequestfromagiven source (available for full load DTPs)
  • Data Transfer Process supports referential integrity checkstor navigational attributes of the target
  • Enhanced load performance by possibility to Re- package small data packages within a request to bigger packages

UNIT 6: Open Hub Service

  • SAP Net Weaver BW data can be exported in XML format
  • Possibility to change the format and length of BW data forexport even intoanon-SAPspecificformat
  • Hierarchy extraction supported by Open Hub

 UNIT7: SAPBODS(NewETLToolof SAP) Integration

Highlights of SAP BW HANA Online training:-

*  Very in depth course material with Real Time Scenarios for each topic with its Solutions for SAP BW HANA Online Trainings.

*  We Also provide Case studies  for SAP BW HANA Online Training.

*  We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.

*  We provide you with your recorded session for further Reference.

* We also provide Normal Track, Fast Track and Weekend Batches also for SAP BW HANA Online Training.

* We also provide Cost Effective and Flexible Payment Schemes.

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.
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.
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.
SAP BW on HANA Benefits:
SAP BW on HANA is smarter, simpler and more efficient.
Customer value of SAP BW on HANA:
  • Excellent query performance for improved decision making
  • Performance boost for Data Load processes for decreased data latency
  • Accelerated In-Memory planning capabilities for faster planning scenarios
  • Flexible – combine EDW with HANA-native data for real-time insights and decision making
  • Data persistency layers are cut off and reduced administration efforts
  • Simplified data modeling and remodeling
Faster decision-making – Having the right information when you need it
In today’s business world, fast access and manipulation is required on top of massive data stores. This is beyond the capabilities of traditional disk-based systems.
SAP HANA helps your SAP NetWeaver Business Warehouse run better than ever. HANA enables you to analyze large amounts of data, from virtually any source, in near real time, making it possible to access reports with up-to-the-minute information. As an example, having the most current order and logistics information makes it possible to manage your inventory more efficiently, and to predict Available to Promise (ATP) more accurately.
Lower Total Cost of Ownership (TCO):
When you take into account the cost of hardware, software licenses, maintenance, performance tuning and project development, SAP BW is always cheaper in terms of TCO when running on HANA.
Whether HANA also is cheaper in terms of Total Cost of Acquisition (TCA) depends on where you are in your procurement lifecycle. Do you have to replace hardware anyhow? Can you free up resources on expensive UNIX equipment? Can you reuse the Oracle or DB2 licenses elsewhere or save on maintenance revenue? Do you have to complete a SAP system upgrade as well? Do you save substantially on storage costs? Many times, the answer is yes!
Simplified configuration and operational management:
Non-disruptive innovation and advanced administrative tools.
The current business processes inside BW can stay as they are and will mesh perfectly with HANA. System operation stays as it is, and process chains do not need to be remodeled.
With HANA there is no need to retrain end users familiar with BW. There is still the same BW application process but, with BW on SAP HANA, it is now possible to run queries, updates and reports much faster than before. Expert users do not need to get retrained because they can continue to use their current BI or other frontend tools.
In addition, HANA supports the BW Analysis Authorization Concept, and can be integrated with NetWeaver Identity Management to ensure security remains intact.

What Are The Prerequisites To Learn SAP BW on Hana?

1. Candidates should have basic knowledge of data warehousing concepts along with excellent business knowledge on different application areas.
2. Experience in the ABAP language will be an added advantage.

Scheduling Demo With Trainer:

If you would like to take the online demo for sap bw on hana trainer can you please make an inquiry or fill the form for demo registration, one of our executives will arrange a meeting with the expert trainer.

Course Finished Certificate :

After finish, the course we provide sap bw on hana course finished certificate of kits technologies looks like

datastage online training




Contact For More Information On SAP Bw On Hana Training        sap bw on hana online training enquiry

SAP BW on Hana Online Training Overall rating: ★★★★☆ 4.4 based on 438 reviews.
5 1

sap bw on hana online training enquiry

Request for demo

BW on HANA Demo By Shankar

Sap BW On Hana Video – Rahul

sap bw on hana online training enquiry

Write A Review 

Review Title
Review Content

Abinitio Training

I Have joined for Course with Kits Technologies course.I am completely confident enough in my subject. I never thought Abinitio is SO BIG and huge!!!Loved learning it for about few week and quite happy now. Thanks Kits Team
- Ramesh


Sccm training done in a good way
- Phani

Oracle DBA Online Training

I have completed AWS Online Training From KITS Online Trainings. my trainer such a knowledgeable person. He taught a concepts easy and understandable manner. I am getting day by day update and easy understanding. Thank for the wonderful opportunity
- John

Best Training Instittue

Very nice material and course video available for your reference anytime. I repeatedly watched videos to learn required knowledge. Anyone would definitely miss out the physical presence inside the class while attending the course . I had lot of disturbance at home while class was going on and it didn't give me any seriousness about subject as I didn't see anyone looking at me if I am listening! This factor, someone is looking at me would definitely make me concentrate subject. Also 4 (four) hours of coaching online and very less interaction with people around makes very less impressive learning
- Rajesh

My Favourite Training Instittue

My learning with KITS Online Trainings was Golden Gate and SAP Basis training and exam preparation It’s been a worthwhile learning experience - the course was easier to understand than and helped memory retention. Also the online support team were so kind and helpful-when i ran out of time and my exam was a month away they extended my access for extra 30 days. Success all the way
- mandeep

sql server dba

I am Srinivas bolla. I took SQL Database Administrator Online training in Kits online trainings. actually I don’t have knowledge about IT sector, When I was approach Kits online trainings. They gave me well support and training. I learnt a lot from them very well experienced faculty.. very much satisfied for the training. I am happy to say my topics are very clear now. I have no doubt about SQL DBA am very thankful to the whole team of Kits online trainings for providing a Excellent training..
- Srinivas

SAP BW on HANA Online Training Tags:

SAP BW On Hana training, SAP BW On Hana Online training institute, SAP BW On Hana jobs, SAP BW On Hana online training, SAP BW On Hana jobs in Hyderabad, SAP BW On Hana training in Hyderabad, SAP BW On Hana jobs in Chennai, SAP BW On Hana openings in Pune, SAP BW On Hana training certification, SAP BW On Hana training course content, SAP BW On Hana online training from India, SAP BW On Hana training classes, SAP BW On Hana interview questions and Answers, SAP BW On Hana study material, SAP BW On Hana classes, SAP BW On Hana tutorial.

online training

India|US|UK|Canada|Australia|Germany|Philippines|New Zealand|Switzerland

Mumbai|Kolkata|Bangalore|Chennai|Kerala|Pune|Hyderabad|Lucknow|New Delhi