SAP HANA 2.0 SPS02 Modeling

Course Details
Code: HA300-v014
Tuition (USD): $3,750.00 • Classroom (5 days)
Contact Us For Pricing

Skills Gained

  • This course will prepare you to:
       -Develop information models following SAP best practices for maximum performance and flexibility
       -Get started with SQL and SQLScript based modeling
       -Manage projects and modeling content in the Web IDE
       -Implement security and data access controls around SAP HANA data models
       -Get a quick overview of advanced data processing such as text, spatial, predictive and graph

Who Can Benefit

  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist


  • Essential:
       -HA100 – SAP HANA Introduction
  • Recommended:
       -HA150 - SAP HANA 2.0 SPS02 - SQL and SQLScript for SAP HANA

Course Details

Course Content

  • Information Views
       -Connect Tables
       -Create Dimension and Cube Calculation Views
  • Modeling Functions
       -Create Calculated and Restricted Columns
       -Filter Data
       -Use Variables and Input Parameters
       -Create Hierarchies
       -Implement Currency Conversion
  • SAP HANA Studio Modeling
  • SAP Supplied Virtual Data Models
       -SAP HANA Live
       -Embedded Analytics and CDS
  • Using SQL in Models
       -Introduce SAP HANA SQL
       -Define the Persistence Layer Using CDS
       -Work with SQLScript
       -Create and Use Functions and Procedures
  • Optimization of Models
       -Implement Good Modeling Practices
       -Use Tools to Maximize Optimization
  • Management and administration of Models
       -Work with Modeling Content
       -Create and Manage Projects
       -Use SAP Enterprise Architecture Designer
       -Overview of Classical Models Migration to Web IDE
  • Security in SAP HANA Modeling
       -Understand the Key Concepts of SAP HANA Security
       -Define Data Access Security
       -Define Roles
  • Overview of Text, Spatial, Predictive and Graph Modeling


  • Most of the activities of this course rely on the SAP Web IDE for SAP HANA, but graphical modeling in SAP HANA Studio is also covered with a dedicated unit.

Course based on software release

  • SAP HANA 2.0 SPS02