7491 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,335 USD
Course Code DBW462-v020
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
  • 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 LT Replication into SAP HANA
       -SAP HANA Smart Data Access
       -SAP HANA Smart Data Integration incl. real-time Streaming
       -Operational Data Provisioning (ODP)
       -Integration Options with Cloud Sources
  • 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 you 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 SP01
  • SAP HANA 2.0 SPS05
  • SAP S/4HANA 2021 FP01
  • SAP HANA Studio 2.3.59
  • SAP BW Modeling Tools 1.24
  • SAP Web IDE for SAP HANA 2.0 SPS05
  • SAP Analysis for Microsoft Excel 2.8