Course announcements

  • In this course, participants will gain an overview over SAP’s main modeling backend systems from native SAP HANA modeling and SAP S/4HANA modeling with ABAP CDS Views to SAP BW powered by SAP HANA, SAP BW/4HANA and SAP Data Warehouse Cloud. Participants will get a comparison of these modeling possibilities and information concerning SAP’s future modeling and data warehouse strategy. Different backend tools will be used in exercises and demos such as SAP HANA Studio, SAP WEB IDE for SAP HANA, ABAP Eclipse, Data Warehouse Workbench, SAP BW Modeling tool. Different frontend tools will be used as well to represent the frontend layer (SAC, SAP Fiori, SAP Analysis for Office, SAP HANA Live Browser, Query Designer).

Course information

  • Native SAP HANA Modeling (SAP HANA 1.0) Prepare your SAP HANA System
    • Launch SAP HANA Studio and create a connection
    • Create Calculation Views of type Dimension
    • Create a Calculation View of type Cube with Star Join
    • Create a Calculation View with a Union Node
    • Native SAP HANA Modeling (SAP HANA 2.0) Launch Web IDE for SAP HANA and set up your development environment
    • Create a Calculation View of Type Dimension in SAP Web IDE for SAP HANA
    • Create a Calculation View and implement a Parent-Child Hierarchy via SAP Web IDE for SAP HANA
    • Create a Calculation View and use Filter via SAP Web IDE for SAP HANA
    • Create a Calculation View and use Variable and Input Parameter via SAP Web IDE for SAP HANA
  • SAP HANA Live
    • Explore SAP HANA Live Calculation Views using SAP HANA Studio
    • Use SAP HANA LIVE Browser
  • Native SAP HANA CDS
    • Define a persistence layer with HANA CDS DDL
  • S/4HANA and Embedded Analytics
    • Prepare your S/4HANA System and explore SAP ABAP CDS views using SAP Logon and ABAP Eclipse
    • Explore VDM ABAP CDS views using the View Browser
    • Explore data with SAP Analytics Cloud
  • Customer-Defined ABAP CDS Views
    • Start ABAP Eclipse, create a new ABAP Project, and add a development package
    • Create a Custom ABAP CDS View with Fiori
    • Create a simple ABAP CDS View with ABAP Eclipse
    • Create a ABAP CDS View with Association with ABAP Eclipse
  • SAP BW powered by SAP HANA and SAP BW/4HANA
    • Advantages of a SAP BW as a Separate Data Warehouse
    • Explore an existing Data Flow in the Data Warehousing Workbench
    • Create a Composite Provider containing two Open ODS Views from different sources
    • Create a simple Query
    • Load data via ODP using SAP HANA Information Views
    • Create an ABAP CDS View DataSource and Load Data
    • Stream data in Real Time with ODP – SLT
    • Work with SAP HANA-Optimized transformation rules
    • Describe the Evolution of SAP BW
  • SAP Data Warehouse Cloud
    • Understand the SAP DWC Concept
    • Understand SAP DWC Integration options
    • Understand SAP DWC Administration options (Space concept)
    • Understand SAP DWC Modeling options
  • Summary
    • Wrap up and comparison of the modeling systems
  • Understand and compare the different data modeling / data transformation possibilities of
    • Native SAP HANA modeling
    • SAP HANA Live
    • ABAP CDS Views
    • SAP BW powered by SAP HANA und SAP BW/4HANA
    • SAP Data Warehouse Cloud
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • Technology Consultant


  • Basic knowledge of Modeling/ Reporting


  • SAP BW75 powered by SAP HANA, SP04
  • SAP HANA 1.0 SPS12
  • SAP HANA Studio 2.3.8 or higher
  • SAP BW/4HANA Modeling Tools 1.1 or higher
  • SAP BusinessObjects Analysis for MS Excel 2.2 or higher
  • SAP Analytics Cloud currently available release
  • SAP Data Warehouse Cloud currently available release
  • SAP HANA 2.0 SP 03
  • S/4HANA Version 1909
  • ECC Netweaver 7.4, SPS 04, with DMIS 2011 SPS 08
  • The course is mainly targeted to participants with basic knowledge of the modeling areas and even for those who are familiar with one of the modeling areas, optional exercises exist to deepen their knowledge.

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more