SAP HANA Modeling (HA300v12)



In this course, you will develop advanced SAP HANA modeling skills, so that you are able to create sophisticated and high performance information views, which can expose data to applications and report consumers.

This course is based on software release:



  • Business application consultant
  • Data consultant / manager
  • Database administrator
  • Application developer
  • BI specialist


  • Basic knowledge of SAP HANA
  • The HA100 course provides a good understanding of SAP HANA and it is mandatory for participants who want to attend this course
  • Basic knowledge of row and column table storage
  • First experience in data modeling
  • Basic SQL knowledge
  • Basic understanding of SAP Business Objects BI products

Learning Objectives

  • Develop information models following SAP best practices for maximum performance and flexibility
  • Advanced data processing such as text, spatial, predictive and graph
  • SQL and SQLScript based modeling
  • Implement security and data access controls around SAP HANA data models

1. Information Views

  • Connect tables
  • Create dimension and cube calculation views

2. Modeling Functions

  • Create hierarchies
  • Create calculated and restricted columns
  • Filter data
  • Use variables and input parameters
  • Implement currency conversion
  • Create decision tables

3. SQL Script and Procedures

  • Introduce SQL and sqlscript
  • Create table functions and procedures
  • Use the SQL debug tools

4. Virtual Data Models in SAP HANA

  • Use SAP HANA live
  • Virtual data models built with core data services (cds)

5. Text, Spatial, Predictive and Graph Modeling

6. Management and Administration Of Models

  • Validate information models
  • Transport information models
  • Rename, copy move models
  • Schema mapping
  • Convert deprecated modeling artifacts using migration tools

7. Security in SAP HANA Modeling

  • Key concepts of SAP HANA security
  • Data access security

8. Optimization of Models

  • Best practices to model design
  • Plan visualizer and explain plan tools