In this course, you will learn how to implement and maintain SAP BW powered by SAP HANA. You will learn the advantages of the new in-memory solution with SAP BW. You will discover the HANA-specific or optimized elements and aspects of SAP BW. With introducing a new Layered Scalable Architecture (LSA++), you will familiarize with a HANA optimized data modeling approach on SAP BW.


  • Technology consultants
  • Project team members implementing and maintaining SAP BW powered by SAP HANA


  • Experience in data modeling with SAP BW 7.x
  • DBW73 - Delta BW 7.0 to BW 7.3
  • DBW74 - Delta BW 7.0 to BW 7.4 (non-HANA)
  • HA100 - SAP HANA - Introduction
  • BW330 - SAP BW Modeling & Implementation
  • HA900 - SAP HANA Live
  • HA350 - SAP HANA - Data Provisioning

Learning Objectives

  • Implement and maintain SAP BW powered by SAP HANA
  • Advantages of the new SAP 'in-memory' database foundation for SAP BW
  • HANA specific features
  • Optimized existing and new data models
  • Functions of SAP BW
  • New SAP architecture framework of LSA++
  • Guidelines on how to convert your existing EDW-architecture
  • Native HANA modeling and how both HANA information views as well as BW InfoProviders can complement each other in so-called mixed scenarios

1. Getting Started

  • SAP HANA Basics
  • SAP BW Basics
  • SAP HANA BW Modeling Tools
  • SAP HANA Native Modeling

2. Migration to SAP BW on HANA

  • Migration Strategies and Tools
  • SAP BW Migration Cockpit

3. BW on HANA Data Management

  • Multi- Data Management
  • Optimizing BW Data Management based on Dynamic Tiering and Non-Active Concept
  • Optimizing BW Data Management based on Nearline-Storage

4. Optimization Areas in BW on HANA

  • HANA-Optimized Data Modeling: InfoCubes
  • HANA-Optimized Data Modeling: Advanced DataStore-Objects
  • HANA-Optimized Data Modeling: Composite Providers
  • HANA-Optimized Data Staging
  • HANA-Optimized Analytic Manager
  • HANA-Optimized Analysis Processes

5. Modeling with SAP�s Reference Architecture LSA++

  • Review of Layered Scalable Architecture (LSA)
  • From LSA to LSA++: Streamline Core Layers
  • LSA++: Open Operational Data Store Layer (Open ODS Views)
  • LSA++: Agile Data Mart and BW Workspace Layer

6. Hybrid Modeling in Mixed Scenarios

  • Generation of HANA-Views of BW InfoProviders
  • Mixed Scenarios
  • SAP HANA Live
  • HANA-Optimized BI Content

7. Data Provisioning into SAP HANA and SAP BW

  • Overview of Data Provisioning Methods to SAP HANA
  • SLT Replication into SAP HANA
  • SLT Replication into SAP BW
  • Operational Data Provisioning into SAP BW
  • DB-Connect and Open Hub Destination

8. Additional Enhancements of BW 7.40

  • InfoObject Enhancements
  • Authorization Enhancements
  • Process Chain Monitoring
  • HANA-Optimized BW Search
  • HANA-Optimized BW Planning
  • Obsolete BW Object Types
  • Mobile Enablement Enhancements
  • SAP HANA vs. BW Accelerator

9. Summary and Outlook

  • New Transactions and BW on HANA Roadmap