Goals

  • This course will prepare you to:
    • Develop information models following SAP best practices for maximum performance and flexibility
    • Get started with advanced data processing such as text, spatial, predictive and graph
    • Get started with SQL and SQLScript based modeling
    • Implement security and data access controls around SAP HANA data models

Audience

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

Prerequisites

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • None

Course based on software release

  • SAP HANA SPS12

Content

  • Information Views
    • Connect Tables
    • Create Dimension and Cube Calculation Views
  • Modeling Functions
    • Create Hierarchies
    • Create Calculated and Restricted Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Implement Currency Conversion
    • Create Decision Tables
  • SQL Script and Procedures
    • Introduce SQL and SQLScript
    • Create Table Functions and Procedures
    • Use the SQL Debug Tools
  • Virtual Data Models in SAP HANA
    • Use SAP HANA Live
    • Overview of Virtual Data Models built with Core Data Services (CDS)
  • Text, Spatial, Predictive and Graph Modeling
  • Management and administration of Models
    • Validate Information Models
    • Transport Information Models
    • Rename, copy move models
    • Define schema mapping
    • Convert Deprecated Modeling artifacts using migration tools
  • Security in SAP HANA Modeling
    • Understand the Key Concepts of SAP HANA Security
    • Define Data Access Security
  • Optimization of Models
    • Apply Best Practices to Model Design
    • Introduction to Plan Visualizer and Explain Plan tools