sap-hana-syllabusTraining Hours: 55
SAP HANA Syllabus:
- Modeler, Administration View, Navigator
Modeling 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
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
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
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
- Persistency Layer
User Management & Security
- Creating users
- Creating Roles
- Assign privileges to Users/ Roles
- Template Roles
- SQL statements for user management
- Analytical privileges, Package Privileges, System
- Privileges , SQL Privileges
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
SAP BW on HANA
- Overview of SAP BW
- SAP BW Powered By HANA as a database
- In Memory Optimized Info Cube
- In Memory Optimized DSO
- Bex Report on SAP HANA Transient Provider
- SAP BW Composite provider on HANA Model
SAP S4 HANA
S4HANA A New Product
• The First Contact to S4HANA
• Impact on SAP HANA Business Processes
• SAP HANA Architecture and Technical Basic Concept
Excercise2:
• 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