“I appreciate the fact that we were able to easily deviate from the book when possible to cover more interesting & advanced topics. [Instructor] is very knowledgeable and honest about BO XI capabilities. Thanks.”
– John F, FedEx
“[Instructor] is very knowledgeable in this subject and is able to communicate information in an easy, understandable manner. I look forward to doing the advanced class…”
– Kimberley G, Rogers Wireless
“This instructor gets a 10 out of 10. He is brilliant and has the expertise and teaching methodology that makes this type of course fun and educational. Highly recommend for future courses!!! OUTSTANDING!!!!!!!!!!!”
– Attendee, Burger King Corporation
Course Description
This course is designed to provide details of SAP HANA Modeling and Model Processing. The course also provides hands on experience with Data Provisioning using SAP Data Services and SLT (System Landscape Transform). Security and authorizations will also be discussed. Extensive hands on exercises are provided for the students.
Audience
This course is targeted for consultants and project team members who wish to gain a deeper understanding of SAP HANA Modeling, Data Provisioning, and Security and Administration.
Objectives
After completing this course, students will be able to create SAP HANA models, understand the different SAP HANA views and learn how to load data using SLT, SAP Data Services and Direct Extractor Connector (DXC). The course discusses several other topics such as Currency Conversion, Decision Tables, Text Processing, Security & Authorizations and more. The course provides extensive hands on workshops in order to reinforce topics taught.
Duration & Version
3 Days – 1.x
Prerequisites
The SAP HANA—Introduction course is mandatory. Experience with data modeling and SQL is recommended.
Topics Covered
Model Processing
Pros & Cons of Data Access methods from SAP HANA
Understanding Joins in SAP HANA
Creating Attribute & Analytical Views
Filters, Variables and Parameters
Hierarchies
SAP HANA SQL
SQLScript and Procedures
Calculation Views
Currency Conversion
Decision Tables
Overview
Data Types and Indexes
Using Full Text Search
Processing Information Models
AFL Overview
Managing Modeling Content
Import/Export Models
User Management and Security
Types of Privileges
Administrative Security
SAP HANA and BI4 Authentication
Overview
Administration and Monitoring
Transformations and Advanced Replication Settings
Filtering Data
Loading Data with Data Services
Overview
Using DXC
Loading Data from Flat Files