Goals

This course will prepare you to:

• Develop information models following SAP best practices for maximum performance and flexibility
• Get started with SQL and SQLScript based modeling
• Manage projects and modeling content in the Web IDE
• Implement security and data access controls around SAP HANA data models
• Get started with advanced data processing such as text, spatial, predictive and graph

Audience

• Business application consultant
• Data Consultant / Manager
• Database Administrator
• Application developer
• BI specialist

Course based on software release

• SAP HANA 2.0 SPS01

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
• SAP HANA Studio Modeling
• Virtual Data Models in SAP HANA
  • Use SAP HANA Live
  • Overview of Virtual Data Models built with Core Data Services (CDS)
• SQL Script and Procedures
  • Introduce SQL and SQLScript
  • Create a Persistence Layer Using CDS
  • Create Table Functions and Procedures
• Management and administration of Models
  • Work with Modeling Content
  • Create and Manage Projects
  • Overview of classical models migration to Web IDE
• Security in SAP HANA Modeling
  • Understand the Key Concepts of SAP HANA Security
  • Define Data Access Security
  • Define Roles
• Optimization of Models
  • Apply Best Practices to Model Design
  • Introduction to Performance and Analysis Tools
• Overview of Text, Spatial, Predictive and Graph Modeling

Notes

• Most of the activities of this course rely on the SAP Web IDE for SAP HANA, but graphical modeling in SAP HANA Studio is also covered with a dedicated unit.