SAP HANA PRACTICAL TRAINING

SAP HANA is an in-memory database and application, which runs on SAP authenticated hardware and Software. … SAP HANA can load data from SAP and Non-SAP data source through SLT, BODS, DXC, and Sybase. SAP HANA provide real-time provisioning and reporting. SAP HANA provide high-performance real-time analytic reporting.

Module 1- SAP HANA Introduction

1. Introduction to SAP HANA
2. Evolution of HANA
3. SAP HANA IMDB storage types
4. Strategy and Technology
5. HANA compare to BWA
6. HANA Landscape
7. In‐Memory Computing Product
8. Strategy and Roadmap
9. Compression and portioning
10. HANA In-memory

Module 2 - Sizing Look And Feel

1. In‐Memory Computing Studio
2. Administration view
3. Navigator View
4. System Monitor
5. Information Modeler

Module 3 - SAP HANA Architecture

1. SAP HANA Architecture Overview
2. IMCE and Surroundings
3. Row Store
4. Benefits of Replication Agent
5. Licensing of SAP HANA
6. Column Store
7. Relational engine and request processing
8. Loading data into HANA
9. Data modeling concepts
10. Reporting
11. Edition of Platform and Enterprise
12. Backup & Recovery

Module 4 - HANA Studio

1. Perspective, content and catalogue
2. Developing schema
3. Developing package and attribute view
4. Creating hierarchy and analytical view
5. Benefits of Description Mapping
6. Creation of Analytical View & Hierarchies
7. Distribution making, data Foundation, text join and logical
8. Calculation view
9. Union, join and projection
10. Importance of Save, Attributes, Measures, Variables
11. Find Column
12. SQL script related to HANA
13. Decision table
14. Develop hierarchies and analytical view
15. Analytical privileges

Module 5 - Data Provisioning & Replication

1. Overview of Data Provisioning and Replication
2. Data Services
3. BODS and HANA
4. Full Extractor though ODP
5. Data provisioning using SLT and its features
6. Main benefits of SLT replication server and trigger based approach
7. Architecture for SAP and non SAP source replication
8. Start load replication
9. SLT best transformation concept
10. Filter and selective data replication
11. Configuration and monitoring dashboard for HANA LTR
12. Stop and suspend replication
13. Developing new configuration for SAP and Non SAP sources
14. Status monitoring in HANA studio
15. Advanced replication settings
16. Launching data provisioning UI in HANA Studio
17. New configuration of SAP and Non-SAP sources
18. SAP Landscape replication server for HANA
19. Data provisioning using SAP direct Extractor connection DXC
20. Using business content extractor
21. Importance of DXC
22. Data source extractor concept
23. Tracking data loads
24. Develop info package and data load scheduling
25. Data source activation in source system
26. Configure Import server

Module 6 - Modeling

1. Introduction to Information Modeler
2. Levels of Modeling
3. Attribute Views
4. Analytic Views
5. Calculation Views
6. Export & Import Trigger‐based replication with Landscape
7. Approaching HANA Modeling Connecting tables
8. Advanced Modeling features
9. Hierarchies
10. Restricted & Calculated Measures
11. Filter Operations and Variables
12. Currency conversion
13. Introduction to SQL Script and Script based
14. Processing Information Models
15. Managing Modeling Content
16. HANA User Management and Privileges

Module 7 - Reporting

1. Crystal Reporting in HANA
2. HANA, Reporting Layer and Connectivity option
3. Business Objects BI 4.0
4. Business Objects BI 4.0 Explorer
5. Business Objects BI 4.0 Enterprise
6. Crystal Reports via ODBC/JDBC Connections
7. Others, MS Excel based Reporting
8. Developing connection, business layer, dashboards and data foundation

Module 8 - 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

Module 9 - BW HANA

1. HANA BW DB2 Migration Process
2. BW with HANA DB vs DB2

Regular Batch: 18 – 20 Session.(2hrs)

Weekend Batch: 12-14 Sundays. (3hrs)

Fast Track: 15-20 Days. (4hrs)

Eligibility : 12th+ Having basic knowledge of Computer

ENQUIRE NOW
+91 7065737300