SAP HANA Modeling – Implementation online training

SAP HANA 1.0 Course Content

Introduction
1.Introduction to SAP HANA
2.SAP In-Memory Strategy
3.HANA compare to BWA
Look and Feel
1.In-Memory Computing Studio
2.Administration view
3.Navigator View
4.System Monitor
5.Information Modeler
Architecture
1.Architecture Overview
2.IMCE and Surroundings
3.Row Store
4.Column Store
5.Loading data into HANA
6.Data Modeling
7.Reporting
8.Persistent Layer
9.Backup & Recovery

Data Provisioning
Method 1–Data Provisioning using FLAT FILES
Method 2–Data Provisioning using BODS 4.0 (ETL Based Approach –Building AGILE Data Marts)
1.BODS 4.0 Architecture in detail
2.Data Stores in BODS
3.Meta Data
4.BODS Objects and components Hierarchy
5.Building Data Flows in Designer (to Load the Data to SAP HANA)
6.Query Transform in the Data Flow
7.Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
8.Using Merge Transforms, Date Generation Transforms, SQL Transforms, Pivot Transforms, Reverse Pivot, Match Transform, Match Results Transform, Case Transforms, Validation Transforms, KEY Generation Transform, R Generation Transform, Table Comparison Transform, History Preservation Transform, Map operation Transform with Insert, Map Operation transform with Updates in BODS Data Flow to load the data to SAP HANA
9.Creating Repository Users
10.Creating a Local Repository
11.Setup Central Management Server (CMC)
12.Setup of Data Service Job Server
13.Creating Central repository and using it
14.Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA Scenarios, FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
15.Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc)
16.Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS

Method 3–Data Provisioning using SLT
1.Positioning and Key Concepts
2.Overview on Configuration Aspects
3.SLT based Transformation concepts
4.ABAP includes in SLT transformations
5.Selective Data replication
6.Transformation of data
7.Extension of (target) table Structure
8.Specific Considerations
Method 4–Data Provisioning using Direct Extractor Connection (DCX)
1.Using SAP provided Business Content Extractor
2.ABAP Data Flows for Table and Pool clusters

Modeling
1.Purpose of Information Modeler
2.Levels of Modeling in SAP HANA
3.Attribute Views
4.Analytic Views
5.Calculation Views
6.Creating Advanced Calculation Views using GUI and SCRIPT methods
7.Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
8.Export & Import –Server and Client sides
9.Using Hierarchies (Level Based and Parent-Child Hierarchies)
10.Creating Restricted and Calculated Measures
11.Using Filter Operations
12.Using Variables, input parameters
13.SAP HANA SQL Introduction
14.SQL Script and Procedures
15.Using Currency Conversions, Create hyperlinks
16.Persistency Considerations

SAP HANA Engine Overview
Choosing Views For Information
Using SAP HANA Information Composer for Modeling
Procession Information Models
Validating Models
Comparing Versions of Information Objects
Checking Model References
Generate Auto Documentation
Connecting Tables
Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
Managing Modeling Content
Manage Schemas
Import and Export data Models
Copy Information Objects

Reporting
1.HANA, Reporting Layer
2.Connectivity options
3.SAP Business Objects BI 4.0
4.Designing Complex Universes in IDT based on HANA Tables and HANA Views
5.WEBi4.0 on HANA
6.Crystal Report for Enterprise with HANA
7.Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
8.SAP Business Objects BI 4.0 Explorer
9.Designing Information Space based on SAP HANA Information Model using BO Explorer 4.0
10.Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
11.Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
12.Analysis edition for Microsoft Excel, Microsoft Powerpoint
13.SAP Visual Intelligence on HANA
14.Crystal Reports via ODBC/JDBC Connections
15.Others & MS Excel 2010

User Management
Creation of Users
Creation of Roles
Creation of Role Hierarchy
Assignment of Users to Roles
Authentication
IMCE Authorizations
Security and Authorizations
User Management and Security
Types of Privileges
Template Roles
Concepts of SAP BW 7.3 and BW 7.4 on HANA
BW 7.3 and BW 7.4 powered by SAP HANA
In-memory optimized Infocubes
In-memory optimized DSO’s
Migration concepts of BW 7.3 and BW 7.4 on SAP HANA
Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool

User Management
User Management (SAP BI 4.0 Integration)
User Management (Single-Sign-on SSO)
HANA Certification Guidelines
Sample questions and documentation for HANA certification provided(C_HANAIMP_10)
PROJECTS
Designing SAP HANA Tables for Sales, Finance and Inventory scenarios
Designing Attribute Views, Analytical Views and Calculations Views for Sales, Finance and Inventory scenarios
Loading the Data to SAP HANA using SAP BODS (Complex BODS Dataflows)
SLT Transformation of Data
Reporting on Sales Data (Sales Order Header, Item, Schedule Line Reports etc.) using BI 4.0 Reporting Tools
Financial Reporting (Balance Sheet Reports, Income Statements, Consolidated Income Statements, P&L Reports etc.) using BI 4.0 Reporting Tools (like Crystal Report, BO Explorer, MS Excel)