Home » Course » SAP BW on HANA

Course Highlights

» Free Demo Class

» Real Time Experienced Trainers

» Affordable Cost

» Customize Course Curriculum

» Interview Preparaion Tips

» Complete Hands-on Real Time Training

Quick Enquiry




Course Curriculum

R/3 Architecture.
Landscape of SAP.
BW – Introduction, DWH Introduction
SAP Business Warehouse concepts and Overview
Different Source Systems
Star Schema and Extended Star Schema
Difference between OLAP and OLTP Processors

3.x Objects
Info area
Info object Catalog
Info Objects
Application component
Info source
Data source
Transfer rules
Communication structure
Update rules
Info Cubes
Info Package

7.X Objects
Info Area
Info Object catalog
Info objects
Data source
Source system
Application component
Data source
Info Cube
Info package

Flat file extractions (3.x & 7.x)

Master data extraction




Transaction data    extraction

               To DSO

               To Info Cube

               DSO to Info Cube

Data Flow difference between BW3.x and 7.X

Migration Strategyfrom BW3.X to BW7.X

Data mart concept.

Info Providers: (3.x & 7.x)
Info Objects
Introduction to InfoCubes
Types of InfoCubes.
              Standard InfoCube
              Real time Infocube
              Virtual Providers

Introduction to ABAP.
Creating Tables
Creating views
Concepts of Routines and Types of Routines
Field Level Routine, Expert Routine , Start Routine and End Routine

BI Content
Introduction to Meta Data Repository
Introduction to Business content
Grouping & Collection Mode options in BI Content
Finding proper Object in Business Content and Installing Objects.

BEx Query Designer &BExAnalyser.
Calculated key figures
Restricted key figures
Free characteristic
Query monitoring
Navigational Attributes.
Display Attributes.
Assigning hierarchy to Query.
Publish a SAP BI Report


SAP Business content – Extraction
Introduction to Business Content Extraction
Master data Extraction (Attribute, Text & Hierarchy Data)
Transaction data Extraction.

Generic extraction
Generic Data Extraction using-Table, Function Module ,View and Infused Query
Delta Setup in Generic extraction using Generic Delta (extraction Using Time stamp, calendar day, Numeric Pointer)

Logistic Data Extraction
Introduction to Logistic Extraction.
Update methods - Direct delta, Queued delta& V3
Un serialized delta.

Controlling and Profitability Analysis Extraction
Functionality of Account Based and Cost based in CO-PA Extraction
CO-PA Extraction

Introduction to Datastore Object(DSO)
Types of DSO's .
                  Standard DSO
                  Direct-Update DS
                  Write Optimized DSO
Multi Providers & Info set

Analysis Process Designer

Introduction to Transformations
Transformation Rule types (Direct assignment, Time Distribution, read master data, Routines, Constant, Initial value, No update, Read from DSO)
Transformation Rule Groups

Open Hub Destination
Destination As Table(Local & Application server)
Destination As Data Base Table.
Concepts of Info spoke(in 3.x)


Error Stack

Process Chain
Introduction to Process Chain
Creating Master Data Process Chains
Creating Transactional Data Process Chain
Scheduling Process Chains
Creating Meta Chain
Monitoring process chains
Removing from schedule and rescheduling the process chains

Performance Management
Types of Performance Optimization Techniques
Backend or Data Loading Performance Techniques
Deleting Indexes.
Line - item Dimension&High cardinality
Aggregates & Collapse.
Partitioning & Re-Partitioning
DB Statistics
BI Performance Tuning Activities

Introduction to Transportation.
BW system Landscape
Creating of Package and Transport requests
Collecting the objects in BW across the Landscape
Transporting the Objects across the BW Landscape
Deleting and reimporting Transport requests.
Finding transportation Logs and return cods.
Transportation error and Solutions

SAP BW 7.3
New options in RSA1 screen
New Master Data Deletion
Graphical Data flow modelling option in RSA1 screen
Data Flow generation wizard
Data Migration of 3.X flow to 7.X flow
New options in Info Area Context Menu
New options in Create / Edit DSO screen
New options in Create Infocube screen
New Options in DSO.
New options in Transformation.
New options in Execute Tab and DTP Extraction Tab.
Delta Init without Data
Parallel Extraction
Semantic Partitioned Objects
More options while creating Multi Providers
Data Extraction from Multi Provider
Version Management
DB partitioning for DSO
Transformations in Navigational Use of attributes as source fields.

SAP BW 7.4
Features of BW 7.4 Powered by HANA
Overview SAP BW/ BI 7.4 on SAP HANA & further Roadmap
Eclipse based Modeling Tools
Maintenance Composite Provider
SAP HANA optimized Transformations.

Introduction to HANA
Features of HANA
SAP HANA-Optimized Data Store Objects
SAP HANA-Optimized Info Cubes
Consumption of SAP HANA models in BW7.4 on HANA Mixed Scenarios

UAT Activities in Real-Time.

How to Check BW system Before Go-Live

BW, BPC Integration Concepts.

Course Overview


What is SAP HANA?

SAP HANA is a database.SAP HANA is used to store information and get back when it needed. When you install it there will be in SAP HANA.  But, ready to begin to add the data, the information we want to store.

What is SAP BW?

SAP BW is one of the important technological SAP module and the statement is it running of a business data. Every business activity render data; this data is used by organizations in all areas of business.

Serving as a mighty enterprise data warehouse application platform BW provides flexible reporting and analysis tools. It is packaged extensive business intelligence product around data warehouse.  This allows the SAP BI to analyze the data which is important for all determination making in the company.  


SAP BW on HANA in Bestway Technologies is nothing but SAP’s existing NetWeaver BW data warehouse, standing on SAP HANA. BW on HANA supports various process databases and reporting ability that are not possible by using other databases.  Some practicality like organization and DSOs are moved to HANA database to provide much faster process of data, data load performance, inquiry processing and optimization, particular HANA modeling capabilities, etc.


SAP BW on HANA is the most preferable skill in most of the IT industries. SAP BW on HANA is the next wave of SAP’s in-memory technology imaging that allows SAP NetWeaver BW to use SAP HANA as a fully process in-memory database. By operating SAP BW on HANA intensify the performance, easier administration, and modernized IT panorama.

SAP Business Warehouse or SAP BW is an endeavor data warehouse product by SAP which can integrate and change business information from any possible source system. SAP BW using SAP HANA was the first application by SAP to run solely on SAP HANA, and SAP BW 7.5 is the latest update in SAP BW. SAP is known for Data Warehousing worldwide and clients will increase vastly from the planning functions, query runtime, and better in data load seen in this product. This has extremely easy data modeling and reduced Information Provider. Also, all data modeling is through within a new user program which is distinct across all modeling tools.

Who should attend this Training?

This extensive course is meant for professed who aim to build a career or upgrade knowledge in SAP BW on HANA. This course is best suited for the following professionals:
1. SAP BW Practitioners
2. SAP BW Application Consultants
3. SAP Technical and Functional Consultants
4. Professionals with interest in Data Warehousing
5. Software Analysts and Mainframe professionals
6. Project Managers and Business Objects Professionals
7. Those aspirant for a career in SAP BI/BW

SAP supports SAP HANA as the inherent database for the NetWeaver BW data warehouse. Because, SAP HANA is much faster than regular relation databases like Oracle or Microsoft SQL server. SAP BW on HANA introduced to incorporate the power of both. Migrating BW system to run on HANA is to make it run substantially faster and another reason to move interact system to HANA could be improvement in performance.



  • There is no specific technology background required.
Our BW On HANA Trainers have highly experience in Support, Implementation and Rollout projects real time solutions on different scenarios and expert in their professionals. BESTWAY Technologies verifies their technical background and experience.
We record each live class session you undergo through this training and we will share the recordings of each class.

Yes we will schedule SAP BW7.4 on HANA demo class as per the student convenient time by sharing live online streaming access either through Gotomeeting or Webex..

Our SAP BW on HANA Trainer will provide detailed installation of required Software through Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course. 

If you are enrolled in classes and you have paid fees, but want to cancel the registration for certain reason, it can be done within 48 hours of initial registration. Please make a note that refunds will be processed within 25 days of prior request.

  • We are one of the best SAP BW on HANA online training providers in world, We have learning sap customers from India, USA, Singapore, Canada, UK, UAE, Australia, New Zealand, Qatar, South Africa, Malaysia, Saudi Arabia, Mexico, Ireland, Denmark, Sweden and other parts of the world. We are located in India. Offering Online Training in Cities like Hyderabad, Bangalore, Delhi, Mumbai, Chennai, Pune, Kolkata, Ahmedabad, Patna, Jaipur, Lucknow, Kochi, Indore, Chandigarh, Bhopal, Sūrat, Kanpur, Coimbatore, Visakhapatnam, Vadodara, Gurgaon, Guwahati, Ludhiana, Allahabad, Nagpur, Noida, Mysore, Ranchi, Bhubaneswar, Faridabad, Raipur, Vijayawada, Jamshedpur, Hubli, Tirupati, Guntur, Kakinada, Rajahmundry, Nellore, Anantapur, Eluru, Warangal, Nizāmābād, Secunderabad, Salem, Trivandrum, kerala, Hubli, Bellary, Gulbarga, Hospet, Tumkur, Thane, Navi Mumbai, Kalyan, Nashik, Aurangabad, Solapur, Gandhinagar, Shenzhen, Hong Kong, Tokyo, Yokohama, Nagoya, Fukuoka, Kobe, Copenhagen, Osaka, Kyoto, Nairobi Kenya, Mombasa, Kisumu, Lagos Nigeria, Ibadan, Abuja, Benin, Sydney, New York, New jersey, Melbourne, Dallas, Adelaide, Perth, Brisbane, London, Paris, Berlin, Vienna, Barcelona, Rome, Madrid, Prague, Munich, Milan, Bucharest, Istanbul, Moscow, Birmingham, Seattle, Baltimore, San Jose, San Marcos, Franklin, Chicago, Philadelphia, Jacksonville, Towson, Minneapolis, Los Angeles, Davidson, Murfreesboro, Houston, San Francisco, Atlanta, Alexandria, San Diego, Washington DC, Sunnyvale, Santa clara, Carlsbad, Tacoma, California, St. Louis, Edison, Raleigh, Nashville, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Salt Lake City, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Cape Town, Johannesburg, Durban, Dubbai, Abu Dhabi , Sharjah, Riyadh, Jeddah, Sanaa, Aden, Yemen, Muscat Oman, Kuwait, Doha, Brisbane, Wellington, Auckland, Kuala Lumpur, George Town, Jurong East etc… Hyderabad - Ameerpet, SR Nagar, KPHB, Gachibowli, Dilsukhnagar, madhapur, tarnaka, kukatpally, himayat nagar, Bangalore - Banashankari, Bannerghata Road, Basaveswara Nagar, BTM Layout, Domlur, Electronic city, H S R Layout, Indira Nagar, J P Nagar, Jaya Nagar, K R Puram, Koramangala, Krishnarajapuram, Madivala, Malleswaram, Marathahalli, Mathikere, R T Nagar, Rajaji Nagar, Ramamurthy Nagar, Richmond Road, Shivaji Nagar, Vijaya Nagar, White Field
yes all the training sessions will be a live online streaming using either through gotomeeting or Webex you will be shared with live meeting access while session starts.
Yes, there are some group discount available if group contain more than two.


Demo Video’s


Add Your Review


SAP BW on HANA Rated 5.0 based on 1 reviews.

By: Kiran, Rating:
I joined BESTWAY Technologies for SAP BW on HANA module. They trained me well and i get job in IBM as SAP Consultant. Thanks BESTWAY..