SAP HANA Modeling

Overview

Course Overview

Course Duration: 5 Days

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

Objectives

Course Objectives
Course 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
Course Certifications

This course is part of the following Certifications:

Prerequisites

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • None
Course ID:
HA300


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.