SAP HANA Training

SAP HANA – Online Training

Call us :   419-408-3178  Email :   training@verity-sol.com

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

OUR ADDRESS

104 Industrial Blvd, Suite P,
Sugar Land, TX, 77479

We are located close to Hwy 59 and
Hwy 90 in Sugar Land , TX

EMAIL US

Phone : 419 408 3178

Back to Top