Course Contents

Introduction

•  Introduction to SAP HANA
• SAP In-Memory Strategy
• HANA compare to BWA

In-Memory Computing, Big Data and SAP HANA

• Introduction to In-Memory Computing and Big Data
• In-Memory Computing and Analytics
• Big Data Introduction
• Introduction to SAP HANA
• SAP HANA as in In-Memory Computing Solution
• SAP HANA as an Enabler of Big Data Solutions
• SAP HANA Capabilities
• SAP HANA Database Concepts…..
• Impact of Modern Hardware on Database System Architecture.

Architecture

• Hana Engine Overview
• IMCE surroundings
• Different HANA Engine Types
• Row Store
• Column Store
• Persistency Layer
• Business Impact of new architecture
• Columnar and Row-Based Data Storage
• Advantages of Columnar Tables

Data Modeling with SAP HANA Studio

• SAP HANA Studio Overview and Terminology
• Getting Started with SAP HANA Information Modeler
• Adding a System
• Opening Perspectives
• Using Quick Launch
• Creating a Package
• Example Scenario
• Building Attribute Views
• Creating an Attribute View
• Defining Table Joins 4
• Defining Output
• Checking, Saving, and Activating Views
• Creating the Time Attribute View
• Building Analytic Views
• Creating an Analytic View
• Copying an Analytic View
• Building Calculation Views Using the Graphical Method
• Implement information models in SAP HANA

Advanced Concepts in SAP HANA Studio

• Derived Attribute Views
• Calculated Attributes
• Restricted and Calculated Measures
• Filter and Variable Operations
• Filters
• Variables and Input Parameters
• Currency Conversion
• Creating a Leveled Hierarchy
• Creating a Parent-Child Hierarchy
• Processing Content Objects
• Previewing Data of Content Objects
• Validating Models
• Comparing Versions of Content Objects
• Viewing Version History of Content Objects
• Switching Ownership of Inactive Objects
• Generating Object Documentation
• Enabling Multilanguage Support for Objects
• Checking Model References
• Viewing the Job Log
• Personalizing Studio
• Versioning
• Checking Model References
• Customizing Perspectives

HANA SQL

• Introduction to SQL script and script based calculation views 5
• Using SQL & Using SQLScript
• Using SAP HANA Studio to Execute SQL and SQLScript Statements
• Table Type Definition
• CREATE TYPE
• DROP TYPE
• INSERT, UPDATE, DELETE statements
• Data definition and access control
• Data Types
• CREATE, ALTER, DROP
• Renaming Columns
• Functions & Expressions
• Procedures introduction
• Writing procedures
• Procedure Calls

Data Provisioning

• Choosing a Data Provisioning Method
• Strategic Considerations
• Technical Considerations

Option 1: Trigger-Based Replication: SAP Landscape Transformation

• How SLT Works
• SLT Configuration
• SLT Administration (Start, Replicate, Stop, Suspend,Resume)
• Extended Features

Option 2: ETL-Based Replication: SAP Data Services

• Preparing SAP HANA to Receive Data from SAP Data Services
• Loading Data

Option 3:Log-Based Replication: Sybase Replication Server and Load Controller
Option 4: Direct Extractor Connection

• DXC Technology
• Important Considerations for the Use of DXC 6

Reporting

• SAP HANA and the SAP BusinessObjects BI Platform
• Overview of the SAP Business Objects Tools
• SAP Business Objects Dashboards (Xcelsius) .
• SAP Business Objects Web Intelligence
• SAP Business Objects Explorer
• SAP Business Objects Analysis
• SAP Business Objects Design Studio
• SAP Crystal Reports
• Connecting SAP Business Objects BI Tools to SAP HANA
• Universes with Open and Java Database Connections (ODBC/JDBC)
• IDT Access to Attributes, Calculations, and Analytical Views
• Connecting to Excel with Open Database Objects (ODO) and MDX
• BICS Connections
• Connectivity Summary

User Management & Administrator

• Security
• Creating Users
• Creating Roles
• Privileges
• User Administration 7

Hot Topics

• BW 7.3 powered by HANA Overview
• Business Suite on HANA Overview
• Rapid Deploy Solutions Overview
• HANA Innovations
• Information Composer
• Exercises

CASE STUDY – COPA Scenario

• Steps:
• Provisioning the relevant tables
• Creating attribute view, analytic view & calculation views for COPA Model