Course announcements

  • In this course, participants will gain an overview over SAP’s main modeling backend systems from native SAP HANA modeling and S/4HANA modeling with ABAP CDS Views to SAP BW powered by SAP HANA and BW/4HANA. 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 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, Analysis for Office, SAP HANA Live Browser, Query Designer).


  • This course will prepare you to:
  • Understand and compare the different data modeling / data transformation possibilities of
  • Native SAP HANA modeling
  • ABAP CDS views
  • SAP BW powered by SAP HANA und SAP BW/4HANA


  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • Technology Consultant



  • None


Course based on software release

  • 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 HANA 2.0 SP 02
  • S/4HANA Version 1805
  • ECC Netweaver 7.4, SPS 04, with DMIS 2011 SPS 08


  • 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
  • Examine the tables used in the VDM
  • Start SAP HANA Studio, create a new ABAP Project, and add a development package
  • Create a simple DDL Source for the table SAIRPORT
  • Review the code of Interface and Composite Views
  • SAP BW powered by SAP HANA and SAP BW/4HANA
  • Log in to SAP BW and navigate in the Data Warehousing Workbench
  • Explore an existing Data Flow
  • 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
  • Summary
  • Wrap up and comparison of the modeling systems