7952  Reviews star_rate star_rate star_rate star_rate star_half

Data Warehousing with SAP BW/4HANA - Delta from SAP BW 7.5 classic to SAP BW/4HANA

Skills Gained This course will prepare you to: -Outlining advantages of the SAP "In-Memory" database foundation for SAP BW/4HANA in general. -Introducing new user interfaces for working with SAP...

Read More
$4,600 USD
Course Code DBW462-v021
Duration 5 days
Available Formats Virtual, Classroom

Skills Gained

  • This course will prepare you to:
       -Outlining advantages of the SAP "In-Memory" database foundation for SAP BW/4HANA in general.
       -Introducing new user interfaces for working with SAP BW/4HANA: SAP BW/4HANA Cockpit and SAP BW/4HANA Modeling Tools.
       -Outlining the SAP BW/4HANA conversion approaches and the related tools for a transformation project.
       -Introducing native SAP HANA XS Advanced modeling in the SAP Web IDE for SAP HANA.
       -Explaining the data models in SAP BW/4HANA and position them in the context of SAP´s reference architecture Layered Scalable Architecture (LSA++).
       -Describing so-called "mixed scenarios" where how both, SAP HANA Calculation Views as well as SAP BW/4HANA objects can complement each other.
       -Outlining other areas of innovation with focus on Business Content, Process Chains, Analysis Processes or Transformations.
       -Describing Multi-Temperature Data Lifecycle Management concepts and its implementation in SAP BW/4HANA.
       -Providing an overview of all source system interfaces and data provisioning methods for consuming data in SAP BW/4HANA.
       -Introducing SAP Core Data Services and related use cases in the context of SAP BW/4HANA: Extraction from SAP S/4HANA including available SAP Content, Statistical Analysis of the Data Warehouse Infrastructure and SAP S/4HANA Embedded Analytics.
       -Describing the impact SAP S/4HANA might have on your SAP BW strategy.

Who Can Benefit

  • Application experts and consultants with a sound experience in SAP BW (non-HANA)
  • Project team members implementing and maintaining SAP BW/4HANA


  • Essential:
       -Several years of hands-on experience in data modeling with SAP BW 7.x
       -BW310 (SAP BW Enterprise Data Warehousing)
  • Recommended:
       -BW330 (SAP BW Data Modeling and Implementation)
       -HA100 (SAP HANA Introduction)

Course Details

Course Content

  • Getting started
       -Training Environment
       -SAP Data Warehousing
       -SAP BW/4HANA
       -SAP BW/4HANA Modeling Tools
       -SAP BW/4HANA Cockpit
  • Paths to SAP BW/4HANA
       -Conversion Strategies and Tools
       -Conversion Approaches
  • SAP HANA Modeling
       -SAP HANA Introduction
       -SAP Web IDE for SAP HANA
       -SAP HANA native Modeling of Calculation Views
       -Differences of HANA Modeling XS classic vs. XS advanced
  • Core Modeling Artifacts in SAP BW/4HANA
       -Advanced DataStore objects
       -Open Hub Destinations
       -Open ODS Views
       -Positioning of these Artifacts in the SAP Layered Scalable Architecture (LSA++)
  • Hybrid Modeling in Mixed Scenarios
       -Generation of external SAP HANA Views for BW/4HANA objects
       -Integration of external SAP HANA Views into XSA modeling
       -Typical use cases for Mixed Scenarios
  • Innovations for Selected SAP BW/4HANA Areas
       -SAP BW/4HANA Content Add-on
       -SAP HANA Analysis Processes
       -Analytic Manager (OLAP engine)
       -SAP HANA-optimized Transformations
       -Process Chains
       -Data Protection Workbench (optional)
  • SAP BW/4HANA Data Lifecycle Management
       -Multi-Temperature Data Management
       -SAP BW/4HANA Data Tiering Optimization (DTO)
  • Data Provisioning into SAP HANA and SAP BW/4HANA
       -SAP HANA Smart Data Access
       -SAP HANA Smart Data Integration incl. real-time Streaming
       -Operational Data Provisioning (ODP)
       -Integration Options with Cloud Sources
       -SAP LT Replication into SAP HANA (optional)
  • SAP BW/4HANA and ABAP Core Data Services
       -Overview of SAP ABAP Core Data Services
       -SAP BW/4HANA Statistical Analysis
       -SAP S/4HANA Extraction based on CDS Views
       -SAP S/4HANA Standard CDS Extractors
       -SAP S/4HANA Embedded Analytics
  • Relation of SAP S/4HANA to SAP BW
       -Impact of SAP S/4HANA on your SAP BW strategy
  • Appendix (optional)
       -SAP BW Workspaces
       -SAP Analytics Cloud
       -SAP BW/4HANA Transaction Codes
       -Glossary of Terms


  • This course provides a very sound foundation of SAP BW/4HANA and contains many references to additional documents and information sources. This course has a very strong focus on hands-on experience based on 30 exercises The intended audience for this training are experts which have several years of experience in developing and maintaining applications with SAP BW 7.x (classic).

Course based on software release

  • SAP BW/4HANA 2021 SP04
  • SAP HANA 2.0 SPS05
  • SAP S/4HANA 2022
  • SAP HANA Studio 2.3.71
  • SAP BW Modeling Tools 1.25.06
  • SAP Web IDE for SAP HANA 2.0 SPS05
  • SAP Analysis for Microsoft Excel 2.8