Prerequisites
To apply for the SAP Hana Training Certification, you need to either:
- Should have basic computer knowledge
- Proficiency in using operating systems like Windows.
- An aspirant should have basic skills in database concepts and SQL.
- Basic programming skills (depending upon the course).
- Aspirants should have good knowledge of SAP software and its various modules.
Course Curriculum
Module 1: Modelling in SAP HANA
- Create Attribute Views
- Design Analytical Views
- Create Calculation Views from multiple analytical Views
- Best Practices while Creating Information Models
- Performance Optimization techniques in SAP HANA
- Currency Conversion
- Variables in HANA
- Meta data import to SAP HANA Using SAP
- Export Models
- Import Models
- SQL Script
- CE Functions
- Procedures
- Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
- Restricted Measures & Calculated Measures & Calculated Attributes
- Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities
- Auto Documentation of Information Models
Module 2: Data Provisioning or Data Loading
- SAP DXC – Direct Extractor Connection
- Flat File Upload to SAP HANA
- SAP BODS : Overview Data Services Workbench and Designer
- Creating Data store for ECC and HANA
- Create Data Services Job and Load the data to
- SAP HANA DB
Module 3: Data Reporting
- SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA
- IMCE Clients – ODBO , ODBC, JDBC, BICS
- Microsoft Excel 2010 Connection to HDB
- Create Universe through Information Design Tool using JDBC Connections
- Web Intelligence Document on SAP HANA Universe
- Design studio
- Lumira
- BO Analysis for Office
- BO Analysis for OLAP
- BO Explorer
- Crystal Reports for enterprise
Module 4: User Management and Security
- Creating users and Roles
- Assign privileges to Users/ Roles
- Template Roles
- SQL statements for user management
- Analytical privileges, Package Privileges, System
- Privileges , SQL Privileges
Module 5: SAP BW on HANA
- Overview of SAP BW
- SAP BW Powered By HANA as a database
- In Memory Optimized Infocube
- In Memory Optimized DSO
- Bex Report on SAP HANA Transient Provider
- SAP BW Composite provider on HANA Model
Module 6: SAP S4 HANA
- The First Contact to S4HANA
- Impact on SAP HANA Business Processes
- SAP HANA Architecture and Technical Basic Concept
- First View in the SAP HANA Database
- SAP Simple Finance as an instance of a new Application
- Introduction into Simple Finance:
- Posting with SAP Fiori
- Ways to S/4 HANA
- Lesson Customer Code Migration from ERP Finance to SAP Simple Finance
- SAP Simple Finance as an instance of a new Application
- Introduction into SAP Fiori
- Fiori Launch Pad
Module 7: COPA Accelerator
- COPA Overview COPA Reporting in HANA
- Architecture for CO-PA Accelerator, Use Case Scenarios , Scope
- DBSL – Data Shared Library Connection for HANA as a secondary Database
- SLT Replication – SAP HANA Model
Module 8: Administration in SAP HANA
- Backup & recovery
- SAP HANA Studio Installation and configuration
- Clients Installation
- Create ODBC Connections
- Monitor HDB
- Multi Version Concurrency Control – MVCC
- IMDB Installation
- Distributed System Handling – Cold backup and Hot backup
- Persistence Layer
Module 9: Conclusion
- Summarize all the points discussed.
