PMtutor SAP HANA

SAP HANA TRAINING IN NIGERIA

Course Duration: 40 hrs

Price: N100, 000

 

SAP BI OVERVIEW:

• ODS
• Info Cube

SAP HANA:

• Overview HANA product strategy
• In Memory Computing (Row Store, Column Store, Persistency Layer, Architectural Concept)
• HANA based Real-time Operational Analytics
• HANA based Agile Data Marts for Rapid Prototyping with Analytic Models
• New Modeling Paradigm in order to provide agility and flexibility from business question to report

SAP BW ON SAP HANA 1.0:

• Introduction to SAP HANA (In-Memory Database and Appliance)
• Migrating to SAP BW, powered by SAP HANA Database
• In-memory optimized DataStore Objects and InfoCubes
• Migration of old DataStoreObjects and InfoCubes to in-memory optimized objects
• SAP BW DataSources using SAP HANA as source system via DB Connect

DATA PROVISIONING:

• Overview
• Trigger Based Replication
• ETL Based ReplicationDirect Extractor Connection
• Log Based Replication
• Introduction to BODS 4
• Defining ABAP Dataflow in DS Designer
• Replicating the meta data to Hana Studio
• Create and execute a Data Service Job to Populate HANA
• Load SAP ECC Data in to HANA
• Load SAP BW Data into HANA

SAP HANA IMPLEMENTATION AND MODELING:

• Understand the purpose of the Information Modeler
• Describe the levels of modeling in Hana
• Create and display data for an attribute view
• Create and display data for analytical view
• Create and display data for an calculation view
• Understand the purpose of the Export / Import Functionality
• Authorizations

REPORTING ON SAP HANA:

• HANA, Reporting Layer and connectivity options
• Business Objects BI 4.0
• Business Objects BI 4.0 Explorer
• Crystal Reports via ODBC/JDBC connections
• Microsoft Excel
• Exercise