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

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

Essential

• HA100 – SAP HANA Introduction

Recommended

• None