Modules Covered in this Training

In this training, attendees learn:
Module 1. Introduction to SAP HANA
Module 2. Look & Feel
Module 3. Architecture
Module 4. Data Provisioning using Flat files, SAP BODS 4.2 and DCX
Module 5. Modeling
Module 6. Reporting
Module 7. User Management
Module 8. DATA Provisioning using SLT
Module 9. Approaching SAP HANA Modeling
Module 10. Connecting Tables
Module 11. Advanced Modeling
Module 12. Processing Information Models
Module 13. Managing Modeling Content
Module 14. Security and Authorizations
Module 15. Concepts of SAP BW 7.4 ON HANA
Module 16. SAP BI 4.1 on HANA
Module 17. Information Composer
Module 18. SAP Visual Intelligence
Module 19. SAP Predictive Analysis (New SPS5)
Module 20. R integration with SAP HANA (New SPS5)
Module 21. Decision Tables in SAP HANA (New SPS5)
Module 22. SAP HANA and SAP Lumira
Module 23. Back and Recovery (New approach of SAP HANA SPS5)
Module 24. Integration With SAP BUSINESS OBJECTS Design Studio (New tool in SAP BO BI 4.1)

New Enhancements for SAP HANA 1.0 with SP7:
1. SAP HANA Lifecycle Manager

The SAP HANA lifecycle manager (HLM) is a tool that users can call from the Lifecycle Management Perspective of the SAP HANA studio. The SAP HANA lifecycle manager includes the functions of the Software Update Manager for SAP HANA and tasks formerly performed by the on-site configuration tool.

The tasks performed by the SAP HANA lifecycle manager are:
 Integrate SAP HANA System in Landscape
 Configure SAP Landscape Transformation (SAP LT) Replication
 Rename SAP HANA System
 Register in System Landscape Directory
 Add Solution Manager Diagnostics Agent (SMD)
 Remove Solution Manager Diagnostics Agent (SMD)

2. SAP HANA Security (New Features and changed Features)
3. New Features in Back and Recovery
4. Unified Data Provisioning (New SPS7)
5. Data Flow Modeling (New SPS6)
6. SAP HANA Extended Application Services SPS7
7. Core Data Services (New SPS7)
8. Browser-Based Integrated Development Environments (New SPS7)

Attendees also learn:
1. Resume Preparation Guidelines and Tips
2. Mock Interviews and Interview Preparation Tips

Topics Covered

1. Introduction to SAP HANA
2. SAP In-Memory Strategy
3. HANA compare to BWA

Look and Feel
1. In-Memory Computing Studio
2. Administration view
3. Navigator View
4. System Monitor
5. Information Modeler

1. Architecture Overview
2. IMCE and Surroundings
3. Row Store
4. Column Store
5. Loading data into HANA
6. Data Modeling
7. Reporting
8. Persistent Layer
9. Backup & Recovery

Data Provisioning
Method 1 – Data Provisioning using FLAT FILES
Method 2 – Data Provisioning using BODS 4.0 (ETL Based Approach – Building AGILE Data Marts)

1. BODS 4.0 Architecture in detail
2. Data Stores in BODS
3. Meta Data
4. BODS Objects and components Hierarchy
5. Building Data Flows in Designer (to Load the Data to SAP HANA)
6. Query Transform in the Data Flow
7. Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
8. 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
9. Creating Repository Users
10. Creating a Local Repository
11. Setup Central Management Server (CMC)
12. Setup of Data Service Job Server
13. Creating Central repository and using it
14. 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.
15. Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc)
16. Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS
17. A) Workbench User Interface

Replication job editor
Datastore editor
Data Flow editor
Monitoring editor
File Format editor

B) Information Steward
Getting started with Cleansing Package Builder
About cleansing data
About cleansing packages
Cleansing package types
Create cleansing packages
Assign standard forms and variations
Updating a published cleansing package
Viewing published cleansing packages
Person and firm cleansing

Method 3 – Data Provisioning using SLT
1. Positioning and Key Concepts
2. Overview on Configuration Aspects
3. Selective Data replication

Method 4 – Data Provisioning using Direct Extractor Connection (DCX)
1. Using SAP provided Business Content Extractor
2. ABAP Data Flows for Table and Pool clusters

1. Purpose of Information Modeler
2. Levels of Modeling in SAP HANA
3. Attribute Views
4. Analytic Views
5. Calculation Views
6. Creating Advanced Calculation Views using GUI and SCRIPT methods
7. Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
8. Export & Import – Server and Client sides
9. Using Hierarchies (Level Based and Parent-Child Hierarchies)
10. Creating Restricted and Calculated Measures
11. Using Filter Operations
12. Using Variables, input parameters
13. SAP HANA SQL Introduction
14. SQL Script and Procedures
15. Using Currency Conversions, Create hyperlinks
16. Persistency Considerations
17. SAP HANA Engine Overview
18. Choosing Views For Information
19. Using SAP HANA Information Composer for Modeling
20. Procession Information Models
o Validating Models
o Comparing Versions of Information Objects
o Checking Model References
o Generate Auto Documentation

21. Connecting Tables
o Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)

22. Managing Modeling Content
o Manage Schemas
o Import and Export data Models
o Copy Information Objects

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

User Management
1. Creation of Users
2. Creation of Roles
3. Creation of Role Hierarchy
4. Assignment of Users to Roles
5. Authentication
6. IMCE Authorizations

Security and Authorizations
1. User Management and Security
2. Types of Privileges
3. Template Roles
4. Administrative

Concepts of SAP BW 7.4 on HANA
1. BW 7.3 powered by SAP HANA
2. In-memory optimized Infocubes
3. In-memory optimized DSO’s
4. Migration concepts of BW 7.4 on traditional Database to BW 7.0 on SAP HANA
5. Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
7. Customer Testimonials

User Management
1. User Management (SAP BI 4.0 Integration)
2. User Management (Single-Sign-on SSO)

HANA Certification Guidelines
1. Sample questions and documentation for HANA certification provided (C_HANAIMP_10)