“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
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.
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.
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
The SAP HANA—Introduction course is mandatory. Experience with data modeling and SQL is recommended.
Pros & Cons of Data Access methods from SAP HANA
Understanding Joins in SAP HANA
Creating Attribute & Analytical Views
Filters, Variables and Parameters
SAP HANA SQL
SQLScript and Procedures
Data Types and Indexes
Using Full Text Search
Processing Information Models
Managing Modeling Content
User Management and Security
Types of Privileges
SAP HANA and BI4 Authentication
Administration and Monitoring
Transformations and Advanced Replication Settings
Loading Data with Data Services
Loading Data from Flat Files