SAP HANA

SAP HANA ONLINE TRAINING COURSE CONTENT

Course Content

INTRODUCTION

• Intro to In-Memory Computing
• Evolution of In-Memory Computing at SAP
• History of HANA
• HANA compare to BWA
• HANA vs Traditional DB

ARCHITECTURE

• Hana Engine Overview
• IMCE Surroundings
• Different HANA Engine Types
• Row Store
• Column Store
• Persistency Layer
• Business Impact of New Architecture

MODELING

• Key Concepts in Data Modeling
• Components of HANA data model
• Views
• Analytical Views
• Calculation Views
• Attribute Views
• Connection Tables
• Joins
• Measures
• Filters
• Common Scenarios
• Choosing View for the information Model
• Persistency Considerations
• Variables

ADVANCE MODELING

• Calculation View
• Functions & Expressions
• Procedures
• Procedures Scenarios
• Debugging & Troubleshooting
• SQL Script
• Hierarchies
• Restricted & Calculated Measures
• Filter Operations and Variables
• Currency Conversion

DATA PROVISIONING

• Overview
• Trigger Based Replications
• ETL Based Replications (BODS)
• LT Replications (SLT)
• Intro to BODS 4
• Basic Data Service Connection Types
• Full Extractor though ODP

SECURITY

• Creating Users
• Connectivity Creating Roles
• Privileges
• User Administrations

REPORTING

• Connectivity Options
• Business Objects BI 40
• Business Objects BI 40 Explorer
• Business Objects BI 40 Enterprise
• Crystal Reports via ODBC/JDBC Connections
• Others & MS Excel

MISCELLANEOUS

• BW 7.3 Powered by HANA Overview
• SAP HANA Roadmap
• HANA today
• HANA 2.0 (Suite)
• The BW – HANA Relationship
• In-Memory DSO & Cube Overview