SAP HANA 2.0

The SAP HANA 2.0 SPS05 course helps the candidate to possess the required knowledge in the area of the SAP HANA 2.0 (SPS05) for the profile of an SAP HANA technology consultant. This course builds on the basic knowledge gained through related SAP HANA training and preferably refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. Furthermore, the "SAP HANA 2.0 SPS05 course the candidate to aquire the knowledge of installing SAP HANA required by the profile of an SAP HANA technology consultant.

Objective

After the completion of this course, Trainee:

Can load balance read-intensive operations between a primary and secondary instance of SAP HANA with the active enabled mode.
Can automate orchestration of HA/DR processes with enhanced SAP Landscape Management integration.
Can optimize workload for 3rd party backup tools by consolidating SAP HANA log backups.
Can protect data at rest by using SAP HANA’s comprehensive encryption for data and redo log files.
Can reduce TCO by using existing LDAP groups for automatic role assignment.
Can simplify monitoring of security alerts and configuration of security and users in the new SAP HANA cockpit.
Can manage one instance, multiple tenants or thousands of SAP HANA instances within the SAP HANA Cockpit administration tool.
Can prevent run-away queries and manage system thresholds with enhanced workload management.
Can reduce time and cost when implementing change by capturing, comparing and analyzing multiple workload replays.

Pre-Requisites

1. Basic knowledge on relational database and SQL
2. Knowledge of SAP BW
3. Knowledge of any ERP business process

Target Audiance

The SAP HANA 2.0 is suited for the following professionals:
1. BW Application Consultants
2. Business Analysts
3. Developers
4. Technical/Functional Consultants

Certification

Please see below the list of topics that may be covered within this course. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

SAP HANA Installation, Configuration and Upgrade 12%

SAP HANA Database Administration 12%

SAP HANA High Availability and Disaster Recovery 12%

SAP HANA Architecture and Deployment Options 8% – 12%

SAP HANA Backup and Recovery 8% – 12%

SAP HANA Database Security 8% – 12%

SAP HANA Monitoring and Troubleshooting 8% – 12%

Database Migration Options for SAP HANA 8% – 12%

Course Contents

Introduction to SAP HANA
SAP In-Memory Strategy
HANA compare to BWA

Architecture Overview
IMCE
Row Store
Column Store
Loading data into HANA
Data Modeling
Reporting
Persistent Layer
Backup & Recovery

Method 1 – Data Provisioning using FLAT FILES

Method 2 – Data Provisioning using BODS 4.0 (BODS 4.0 Architecture in detail

Data Stores in BODS
Meta Data
BODS Objects and components Hierarchy
Building Data Flows in Designer (to Load the Data to SAP HANA)
Query Transform in the Data Flow
Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
Using Merge Transforms, Date Generation Transforms, SQL Transforms, Pivot Transforms, Reverse Pivot, Match Transform, Match Results Transform, Case Transforms, Validation Transforms, KEY Generation Transform, R Generation Transform, Table Comparison Transform, History Preservation Transform, Map operation Transform with Insert, Map Operation transform with Updates in BODS Data Flow to load the data to SAP HANA
Creating Repository Users
Creating a Local Repository
Setup Central Management Server (CMC)
Setup of Data Service Job Server
Creating Central repository and using it
Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA Scenarios,FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc)
Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS

Method 3 – Data Provisioning using SLT

Positioning and Key Concepts
Overview on Configuration Aspects
Selective Data replication

Method 4 – Data Provisioning using Direct Extractor Connection (DCX)

Using SAP provided Business Content Extractor
ABAP Data Flows for Table and Pool clusters

Purpose of Information Modeler
Levels of Modeling in SAP HANA
Attribute Views
Analytic Views
Calculation Views
Creating Advanced Calculation Views using GUI and SCRIPT methods
Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
Export & Import – Server and Client sides
Using Hierarchies (Level Based and Parent-Child Hierarchies)
Creating Restricted and Calculated Measures
Using Filter Operations
Using Variables, input parameters
SAP HANA SQL Introduction
SQL Script and Procedures
Using Currency Conversions, Create hyperlinks
Persistency Considerations
SAP HANA Engine Overview
Choosing Views For Information
Using SAP HANA Information Composer for Modeling
Procession Information Models

Validating Models
Comparing Versions of Information Objects
Checking Model References
Generate Auto Documentation

Connecting Tables.

Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)

Managing Modeling Content.

Manage Schemas
Import and Export data Models
Copy Information Objects

HANA, Reporting Layer
Connectivity options
SAP Business Objects BI 4.1
Designing Complex Universes in IDT based on HANA Tables and HANA Views
WEBi 4.0 on HANA
Crystal Report for Enterprise with HANA
Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
SAP Business Objects BI 4.1 Explorer
Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
Analysis edition for Microsoft Excel, Microsoft Powerpoint
SAP Visual Intelligence on HANA
Crystal Reports via ODBC/JDBC Connections
Others & MS Excel 2010

Creation of Users
Creation of Roles
Creation of Role Hierarchy
Assignment of Users to Roles
Authentication
IMCE Authorizations

User Management and Security
Types of Privileges
Template Roles
Administrative

BW 7.3 powered by SAP HANA
In-memory optimized Info cubes
In-memory optimized DSO’s
Migration concepts of BW 7.4 on traditional Database to BW 7.0 on SAP HANA
Migrating standard Info cubes to In memory optimized Infocubes using migration Tool
Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
Customer Testimonials