Sap Hana Training
Sap Hana Training
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
