SAP HANA Implementation & Modeling

Module 1: Approaching SAP HANA Modelling

• Persistency Considerations
• SAP HANA Engine
• Choosing Views for the Information Model

Module 2: Overview of Connecting Tables

• Connect Tables Using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Unions

Module 3: Advanced Modelling

• Creating Attribute View
• Using Hierarchies
• Creating Restricted and Calculated Measures
• Using Filter Operations
• Using Variables
• Creating Calculation Views
• SAP HANA SQL – Introduction
• SQL Script and Procedures
• Using Currency Conversion

Module 4: Overview of Full Text Search

• Data Types and Full Text Indexes
• Using Full Text Search

Module 5: Processing Information Models

• Model Validation
• Set Preferences for Validation Rules
• Execute Validation Rules
• Object Versions
• References- Checking Model References
• Auto Documentation

Module 6: Managing Modelling Content

• Schemas
• Delivery Units, Packages and Models in Perspective
• Import and Export
• Copying Information Objects
• Copying Content Delivered by SAP
• Translating Metadata Texts
• Repository Translation Tool (RTT)
• RTT Usage Examples

Module 7: Security and Authorisations

• User Management and Security
• Types of Privileges
• Template Roles
• Administrative

Module 8: Data Provisioning Using SLT

• Positioning and Key Concepts
• Overview of Configuration Aspects
• Data Replication at a Glance
• Administration and Monitoring at a Glance
• SLT Based on Transformation Concepts and Advanced Replication Settings
• Extension of (Target) Table Structure and Partitioning
• Transformation of Data
• Filtering and Selective Data Replication
• Specific Considerations

Module 9: Data Acquisition Using SAP Data Services

• Introduction to SAP Data Services
• Loading Data into SAP HANA

Module 10: Data Provisioning Using Flat File Upload

• Flat File Upload
• Loading Flat File Data into SAP HANA

Module 11: Direct Extractor Connection

• Rationale SAP HANA Direct Extractor Connection (DXC)
• SAP HANA Direct Extractor Connection Details
• SAP Business Content Data Source Extractors
• SAP HANA Direct Extractor Connection Setup and Configuration
• Comparison with Other SAP HANA Data Acquisition Techniques