Top SAP HANA Courses Online - enroll today

SAP HANA Online Training

SAP HANA Online Training Course Content

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