SAP HANA Training
SAP HANA Training Outline
Overview – SAP HANA
• Explain what SAP HANA is
• Comprehend the HANA components and their arrangement
• Understand for whom is SAP HANA relevant
SAP HANA 1.0: Look and Feel
• Understand concepts such as HANA and SAP In-memory computing
• Understand the structure of SAP HANA studio
• Understand how to configure perspectives
• Understand how to create a package
Architecture
• Give an architectural Overview
• Explain what is the idea behind the row store, technically and theoretically
• Comprehend what a consultant needs to know about it
• Explain the relationship to performance
• Explain what is the idea behind the column store, technically and theoretically
• Comprehend what a consultant needs to know about it
• Explain the relationship to performance
• Explain the persistence layer
Data Provisioning – Data Services and Replication Server
• Understand how the replication server hooks into an R/3 system
• Select Tables
• Schedule the loading
• Understand how real-time works
• Explain the difference compared to DataServices
• Load transactional data
• Load master data
• Explain how DataServices could be used to transfer data our of BW or any other system into HANA
SAP Landscape Transformation (LT Replicator) for Data Replication into SAP HANA
• Real-time (and scheduled) data replication, replicating only relevant data into HANA
• Ability to migrate data into HANA format while replicating data in real-time
• Leverages proven SLO technology (Near Zero Downtime, TDMS, SAP LT)
HANA Development/Modeling Hands on exercise
Adding a System
Importing Metadata
• Configuring Data Services for Metadata Import
• Creating Schemas
• Importing Table Definitions
• Adding Connections
Loading Data into Table Definitions
• Suspending Data Load
• Resuming Data Load
Copying Contents Delivered by SAP
Mapping Logical and Physical Schemas
Setting Preferences for Information Modeler
Modeling — SAP HANA Studio
• Explain how the model of HANA looks like
• Use the Information Modeler
• Comprehend which objects we have in NewDB
• Describe the relationship between tables, joins, views, frontend interfaces etc
• Create different types of views
• Add/ remove/ join tables
• Create basic join operations
• Activate and deploy views
• Explain how to save the models which have been set up via the export function.
• Explain the import possibilities.
SAP HANA Information Modeler Features (SAP HANA 1.0 SPS 3)
• Functionality
• Usability
• Content
• Administration
Creating Information Objects
• Creating a Package
• Creating an Attribute View
• Creating an Analytic View
• Creating a Calculation View
• Managing Attribute Mappings
• Constant Column
• Creating an Analytic Privilege
• Creating Functions
• Creating Calculated Attributes
• Using Currency as Unit of Measure
• Adding Variables
• Searching Related Tables
• Using System Generated Joins
Processing Information Objects
• Previewing Data of Information Objects
• Validating Models
• Comparing Versions of Information Objects
• Viewing Version History of Information Objects
• Switching Ownership of Inactive Information Objects
• Generating Object Documentation
• Migrating Old Calculation Views
• Checking Model References
• Exporting Models to a Server
• Importing Models from a Server
• Exporting Models to a Client
• Importing Models from a Client
HANA SP2 Features SQLScript Version 2 (SQLScript v2)
• Simplification of the language landscape
• Enhancing the available programmable containers
• Consolidate the different available languages
• Import/Export/Transport of programmable containers
Reporting
• Understand connectivity options for reporting on top of Hana
• Understand the BusinessObjects BI4.0 platform and reporting possibilities
• Set up various connectivity to Hana system for reporting
User Management
• You will be able to create new system users and roles, assign read permissions etc.
Security-Auditing
• Explain the extensible auditing infrastructure
• Show how the Audit trail is stored using syslog
• Explain the concept for Audit logging of authorization changes
Scenario: CO-PA R/3 Scenario: CO-PA
• Understand CO-PA being an example in HANA
• Explain the CO-PA model, related tables, short example of the R/3 reports used in this module etc
Scenario: Build SAP HANA report on MS Excel
• Understand how to load CSV file into SAP HANA
• Explain the model, related tables, short example of the reports used in MS excel
Trouble Shooting — Monitoring, Statistic Server, Trouble Shooting
• See running services
• Judge the disk volume usage
• Watch the system load history etc
A Common Database Approach
• Learn why Column Storage is best suited for modern CPUs
• Understand why Column Storage is suited for update-intensive applications
• Explain the consequences of the insert only approach
• Understand the consequences for typical data entry transactions