SAP BW on HANA Course

SAP BW on HANA is nothing but SAP's existing NetWeaver BW data warehouse, running on SAP HANA.

SAP BW on HANA Online Training

SAP BW on HANA is the next wave of SAP's in-memory technology vision that enables SAP NetWeaver BW to use SAP HANA as a fully functioning in-memory database. Running SAP BW on HANA results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in lower total cost of ownership. SAP Business Warehouse (BW) continues to serve as a powerful data warehouse to consolidate data, harmonize master data and provide flexible reporting scenarios. Introducing SAP HANA as database underneath SAP BW was a major breakthrough in various core areas for data warehousing.

What you will learn

The course will introduce the renewed concepts and possibilities when SAP BW is powered by SAP HANA. We’ll introduce the major guiding points and semantics of a data warehouse and demonstrate them in a business scenario, directly in the system. You will learn and experience the latest developments, with SAP BW powered by SAP HANA.

  • Introduction to SAP HANA
  • Architecture Overview

SAP BW on HANA Online Training Course Content


  • Introduction
  • Evolution of HANA Landscape
  • SAP HANA Basics
  • SAP NetWeaver BW 7.3/7.4
  • SAP HANA Vs. BW Accelerator
  • BW Modeling in SAP HANA Studio
  • SAP HANA Modeling
  • Migration to BW on HANA and BW Data Management
  • Migration Strategies and Tools
  • SAP BW Migration Cockpit
  • SAP BW on HANA Architecture
  • SAP BW on HANA Data Management
  • Multi-temperature Data Management
  • Optimizing BW Data Management (WARM Data)
  • Optimizing BW Data Management (COLD Data)
  • Optimization Areas in BW on HANA
  • Introduction
  • HANA-Optimized Data Modeling: InfoCubes
  • HANA-Optimized Data Modeling: Advanced DataStore Objects
  • HANA-Optimized Data Modeling: CompositeProviders
  • HANA-Optimized Data Staging
  • HANA-Optimized Analysis Manager
  • HANA-Optimized Analysis Process
  • Modeling of SAP BW 7.4 with SAP HANA
  • Models in SAP BW 7.4
  • Data Extraction and Data Flow within SAP BW 7.4 NW 2004S
  • New Data Source Concept of BW 7.4
  • Transformation in BW 7.4 (ETL)
  • DTP (Data Transfer Process)
  • From 3.X to BW 7.4
  • Business Content Upgrading Dataflows
  • COPA
  • Logistics Extraction
  • Administration of InfoCubes and Aggregates
  • ODS view and advanced DSO (Data Store Objects)
  • Virtual Cubes and Multi Providers


  • Modelling with SAP’s Reference Architecture LSA++
  • Review of the Layered Scalable Architecture
  • From LSA to LSA++: Streamline Core Layers
  • LSA++: Open Operational Data Store Layer
  • LSA++: Agile Data Mart and BW Workspace Layer
  • Hybrid Modeling in Mixed Scenarios
  • Generation of HANA-views for BW InfoProviders
  • Mixed Scenarios
  • SAP HANA Live
  • HANA-Optimized BI Content
  • Data Provisioning into SAP HANA and SAP BW
  • Overview of Data Provisioning into SAP HANA
  • SLT Replication into SAP HANA
  • SLT Replication into SAP BW
  • Operational Data Provisioning into SAP BW
  • DB-Connect and Open Hub Destination
  • Additional Enhancements of SAP BW 7.4
  • InfoObject Enhancements
  • Authorization Enhancements
  • Process-chain Monitoring
  • HANA-Optimized BW Search
  • HANA-Optimized BW Planning
  • Obsolete BW Object types
  • Mobile Enablement Enhancements
  • SAP HANA Versus BW Accelerator

Back to top