SAP HANA - Implementation and Modeling

Goals

• Implement information models in SAP HANA
• Replicate data using SAP Landscape Transformation (SLT)
• Load data using SAP Data Services

Audience

• This course is for consultants, project team members and data modellers seeking to optimise reporting performance using SAP HANA. It builds on the introduction provided in the HA100 or TZHANA course and teaches more advanced modelling and structuring techniques. The objective is to enable students to create ever more efficient reporting applications.
• • Application Consultants
  • Project team members
  • Data Modeling Consultants

Prerequisites

• HA100 or HA100R

• Experience in data modeling
• Basic understanding of SQL

Course based on software release

• SAP HANA 1.0 SPS04 (Revision 28)

Content

• Approaching SAP HANA modeling
• Connecting tables
• Advanced modeling features including
• • Hierarchies
  • Restricted & calculated measures
  • Filter operations and variables
  • Calculation views
  • Currency conversion
• Introduction to SQL script and script based calculation views
• Full text search
• Processing information models
• Managing modeling content
• SAP HANA user management and privileges
• Trigger-based replication with SAP Landscape Transformation (SLT)
• Data provisioning using SAP Data Services
• Uploading data from flat files
• Utilizing SAP Direct Extractor extraction (DXC)

Popular tags

No tags submitted for this course yet