HA300 SAP HANA Implementation and Modeling

Duration
5 day(s)
Price
32 000

Content

Course version: 012

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

Search in our courses

Sign up for course

Choose date and place

Heidi Jakobsen Strømme

Produktansvarlig
Send me an email!