• Implement information models in SAP HANA
  • Replicate data using SAP Landscape Transformation (SLT)
  • Load data using SAP Data Services


  • This course is for consultants, project team members and data modelers seeking to optimize reporting performance using SAP HANA. It builds on the introduction provided in the HA100 course and teaches more advanced modeling and structuring techniques. The objective is to enable students to create ever more efficient reporting applications.
    • Application Consultants
    • Project team members
    • Data Modeling Consultants




  • Experience in data modeling
  • Basic understanding of SQL

Course based on software release

  • SAP HANA 1.0 SPS05 (Revision 45)


  • Approaching SAP HANA modeling
  • Connecting tables
  • Advanced modeling features including
    • Hierarchies
    • Restricted & calculated measures
    • Filter operations and variables
    • Calculation views
    • Introduction to SQL script
    • SQL Script and Procedures
    • Currency conversion
  • Full text search
  • Processing information models
  • Managing modeling content
  • SAP HANA user management and privileges
  • Trigger-based replication with SAP Landscape Transformation (SLT)
  • Data provisioning using SAP Data Services
  • Uploading data from flat files
  • Data Provisioning using SAP Direct Extractor extraction (DXC)

Related Curricula