Reviews 4.9 (4.6k+)
4.7/5
SAP Bw On HANA Certification Training
One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.
About Course
🌐 What is SAP BW on HANA?
- SAP BW (Business Warehouse) is SAP’s enterprise data warehousing solution.
- With HANA (High-Performance Analytic Appliance) as its database, BW becomes much faster, enabling real-time reporting, simplified data models, and advanced analytics.
- Training usually covers BW modeling, extraction, transformation & loading (ETL), administration, and reporting optimized for HANA.
🎯 Who Should Learn?
- SAP BW consultants upgrading to HANA
- SAP ABAP/BI developers
- Data warehousing professionals
- Analytics/reporting professionals
💻 Mode of Training
- Live instructor-led online sessions (Zoom, Teams, etc.)
- Self-paced recorded sessions
- Labs with SAP BW/4HANA or BW 7.5 on HANA system access
📑 Deliverables
- Training materials (PDF, PPT, notes)
- System access (practice environment)
- Case studies and project scenarios
- Certification guidance (SAP BW/4HANA certification is common)
SAP Bw On HANA Training Course Syllabus
Unit 1: Introduction to SAP BW On Hana
- Evolution of HANA Landscape
- SAP HANA Basics
- SAP BW on HANA
Unit 2: SAP HANA and Business Strategy
- Identifying Transformational Opportunities
- Understanding Your Needs, Enterprise Needs, and Data Needs
- Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA
- Does SAP HANA Replace BW on HANA?
- Pros and Cons of BW on HANA
- Pros and Cons of SAP HANA
Unit 3: HANA-optimized DataStore Object and InfoCube
- HANA-Optimized Data Store Object
- HANA-Optimized Info Cube
- Semantically Partitioned Object
Unit 4: SAP HANA modeling in SAP BW On Hana
- Purpose of Information Modeler
- Levels of Modeling in SAP HANA
- Attribute Views
- Analytic Views
- Calculation Views
- Export & Import
Unit 5: MODELING of SAP BW on HANA with SAP HANA
- Models in SAP BW on HANA
- Data Extraction and Data Flow within SAP BW on HANA
- Transformation
- DTP (Data Transfer Process)
- Administration of InfoCubes and Aggregates
- DSO (DATA STORE OBJECTS)
- 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 optimized info cubes
- Importing HANA optimizes DSO
Unit 7: DATA EXTRACTIONS (ETL)
- ECC Extractions
- Overview of ECC6.0 Extractions.
- Generic Extractions
- Business Content Extractions
- CO-PA Extractions (COST PROFITABLE ANALYSIS)
- LO-COCK PIT Extractions (LOGISTICS)
Unit 8: REPORTING
- Introduction to BI Enterprise Reporting
- Navigating in Reports
- First Steps in Query Designer
- Key Figures
- CHARACTERISTICS
- Attributes
- Exceptions and Conditions
Unit 09: Transporting Objects (CTO)
- Hybrid provider
- Generic delta functionalities for further types of Data Sources
- Hierarchies
- Data Transfer Process (DTP)
- Open Hub Service
- Transformation
- SAP BODS (New ETL Tool of SAP) Integration
Unit 10: The Multi-dimensional Model in SAP BW
- The SAP BW Star Schema Concept
- Data warehousing Workbench (DWB)
- Info Objects
- Info Cubes
Unit 11: Data Extraction
- Loading Master Data (Attributes, Texts, Hierarchies)
- Loading Transaction Data
Unit 12: New Data source Concept of BW on HANA
- Overview of new Datasource
- Migration of 3.x data source to BW 7.4/on HANA data source (LOGISTICS)
Unit 13: Transformation in BW 7.4(ETL)
- Transformation
Unit 14: DTP (Data Transfer Process)
- Overview of DTPS
- Trouble shooting techniques in DTPS
- Debugging ABAP routines Using DTPS
Unit 15: Business Content
- Business Content (BCT)
Unit 16: Administration of Info Cubes and Aggregates
- Managing Basic Cubes
- Aggregates
Unit 17: DSO (DATA STORE OBJECTS)
- Data Store Objects concept
Unit 18: Virtual Cubes and Multi Providers
- Virtual Cubes
- Multi Providers
- DATA EXTRACTIONS (ETL)
- ECC extractions using BW on HANA Data flows
Unit 19: Overview of ECC6.0 Extractions
- Types of ECC extractions
Unit 20: Generic Extractions.
- Generic Extraction using
- Database Table
- View
- Classical Info sets.
- Functional Module.
Unit 21: Business Content Extractions
- Overview of Business Content Extractions.
- Examples from Financial, Logistics, and HRMS modules
Unit 22: Process Chains in Detail covering all process Types
- Real time examples on process Chains (Meta Chains)
- REPORTING
Unit 23: Introduction to BI Enterprise Reporting.
- The SAP BI Overview
Unit 24: First Steps in Query Designer
- Query Designer
- Info providers in query Designer
Unit 25: Key Figures
- Restricted Key Figures
- Calculated Key Figures
- Properties of Key Figures
Unit 26: CHARACTERSTICS
- Properties and Attributes of Characteristics
- Integrating attributes and hierarchies in reports.
Unit 27: Exceptions and Conditions.
- Exceptions
- Conditions
Unit 28: Transporting Objects (CTO)
- NEW ENHANCEMENTS OF SAP BW on HANA
UNIT 29: 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 30: Data Transfer Process (DTP)
- Data Transfer Process supports data extraction from Multi Providers
- Option to only load the last request from a given source (available for full load DTPs)
- Data Transfer Process supports referential integrity checks tor navigational attributes of the target
- Enhanced load performance by the possibility to Re- package small data packages within a request to bigger packages
UNIT 31: Open Hub Service
- SAP Net Weaver BW data can be exported in XML format
- Possibility to change the format and length of BW data for export even into a non-SAP specific format
- Hierarchy extraction supported by Open Hub
SAP Bw On HANA Course Key Features
- Live Instructor based training with software
- Certification Oriented content
- Hands-on complete Realtime training
- Flexible schedule demo's & classes
- Live recorded videos access
- Study material provided
- JOB Assistance
Course completion certificate
SAP Bw On HANA Training - Upcoming Batches
Coming Soon
AM IST
Coming Soon
AM IST
Coming Soon
PM IST
Coming Soon
PM IST
Don't find suitable time ?
Request More Information
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
- Schedule your sessions at your comfortable with timings
- Instructor-Led training real time projects
- Certification Guidance
PREFERRED
Self-Paced Learning
- Complete set of live-online training session recorded videos.
- Learn technology at your own pace.
- Get access for lifetime.
Corporate Training
- Learn as a full day schedule with discussions, exercises.
- Practical use cases.
- Design your own syllabus based
FOR BUSINESS
SAP Bw On HANA Online Training FAQ'S
What is SAP BW on HANA?
SAP BW on HANA is SAP’s Business Warehouse solution running on the HANA in-memory database. It enables faster data loading, reporting, real-time analytics, and simpler data models compared to traditional BW on relational databases like Oracle/DB2.
Difference between SAP BW on HANA and traditional SAP BW?
- Traditional BW: Runs on 3rd-party databases, uses OLAP engine for calculations.
- BW on HANA: Runs directly on SAP HANA, leverages in-memory technology, push-down of calculations, eliminates need for aggregates/cubes, provides real-time reporting.
What is an ADSO (Advanced DataStore Object) in SAP BW on HANA?
ADSO is the central data storage object in BW on HANA. It combines the features of InfoCubes, DSOs, and PSA. It supports different modeling types (standard DSO, write-optimized, cube-like).
How do you extract data from SAP ECC to BW on HANA?
Using DataSources + ODP (Operational Data Provisioning) framework. ODP is preferred over old RSA7-based extractors because it’s faster and optimized for HANA.
What are the options for real-time data provisioning in SAP BW on HANA?
- SLT (SAP Landscape Transformation Replication) – real-time replication from SAP/non-SAP.
- BODS (BusinessObjects Data Services) – ETL tool.
- DXC (Direct Extractor Connection) – replicates ECC extractors directly into HANA.
- SDA/SDI – virtual access to external sources.
Which front-end tools can connect to BW on HANA?
SAP BEx Query Designer, SAP BusinessObjects tools (WebI, Lumira, Analysis for Office, Design Studio), SAP Analytics Cloud.
Reviews
More Courses You Might Like
No posts found!