SAP S/4 HANA COURSE CONTENT SAP HANA STUDIO Modeler • Administration View • Navigator • System Monitor ARCHITECTURE OF SAP HANA •
Row Store • Column Store • Database engine of HANA • Data modeling • Reporting Architecture • Administration 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 BODS • 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 REPORTING •
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 LANDSCAPE Transformation - SLT • SAP BODS Load to SAP HANA - ODP Enabled Data Sources • 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 - Database Shared Library Connection for HANA as secondary Database • SLT Replication - SAP HANA Model SAP BW ON HANA •
• • • • • •
Overview of SAP BW SAP BW Powered By Hana as database In Memory Optimized Info cube In Memory Optimized DSO Bex Report on SAP HANA Transient Provider SAP BW Composite provider on HANA model