SAP BW 7.5 on HANA Training | SAP BW 7.5 on HANA Online Training

Unit 1: Introduction to SAP HANA Studio

Introduction to SAP HANA

History of SAP HANA

Overview of SAP HANA Studio

SAP HANA Technology Innovations

Describing SAP HANA Basics

Exercise 1: Set Up SAP HANA Studio

Getting Started with SAP BW on HANA

Exercise 2: Log On to SAP BW On HANA

Exercise 3: Use the Delta Merge in SAP BW on HANA

Explaining SAP BW Modeling Tools in SAP HANA Studio

Exercise 4: Set Up BW Modeling Tools

Explaining SAP HANA Modeling

Exercise 5: Create SAP HANA Information Views

Understanding SAP HANA Live

Exercise 6: Work with the SAP HANA Live Browser

Describing SAP S/4HANA Analytics

Unit 2: SAP HANA Architecture

SAP HANA Architecture

Index Server

Persistence Layer

Migration to BW on HANA

Describing Migration Strategies and Tools

Explaining the SAP BW Migration Cockpit

Unit 3: Data Provision Methods

Overview of Data Provision Methods

Flat file Uploading

How to get multidimensional Sales Report

Overview of Business Objects Data Services using ETL-based

Approach

BW on HANA Data Management

Describing Multi-Temperature Data Management

Optimizing SAP BW Data Management (Warm Data)

Exercise 7: Implement the Active/Non-Active Data Concept

Optimizing SAP BW Data Management (Cold Data)

Exercise 8: Work with SAP BW Near-Line Storage

Explaining Data Provisioning into SAP HANA

Exercise 9: Upload a Flat File to SAP HANA

Describing SAP HANA Smart Data Integration Explaining SLT Replication into SAP HANA

Exercise 10: Maintain SAP LT Replication into SAP HANA

Explaining SLT Replication into SAP BW

Explaining Operational Data Provisioning into SAP BW

Exercise 11: Work with ODP to SAP BW type SLT

Exercise 12: Work with ODP type SAP Extractors

Exercise 13: Work with ODP type HANA Information Views

Explaining DB Connect and Open Hub Destination

Exercise 14: Load Data based on DB-Connect

Unit 4: Accounts Payable

Introduction to SAP HANA Information Models

Analytical View for COPA Plan using Attribute views and COPA Actual

How to use join operators in building Calculation View

Methods to Create Calculation View

Unit 5: Overview of SAP BW 7.5 on HANA 1.0

Overview of SAP BW 7.5 on HANA 1.0

Data Warehousing Workbench

Unit6: Migration Strategies and Tools for BW on HANA

High Level Overview on SAP BW on HANA Migration Process

Unit 7: Info Objects and Data Store Objects

Overview of InfoObjects

Creating Characteristics under Catalog

InfoObjects Characteristics and Key Figures

Classification of Master Data

Creating Characteristics

Overview of Key Figures and Data Flow

Overview of Data Store Objects

How to load Transactional Data to Data Store Objects

SAP HANA Optimized DSO

Lookups on Active Data DSO

Unit 8: SAP HANA Info Source and Transformations

Explaining Transformations Framework and Expert Routines

using Scenario based example

Mapping One Source Field to Target Field

Working with Expert Routines

Writing Expert Routines Code in ABAP

Introduction to InfoSource and Execution of two

transformations before executing multiple transformations

InfoSource as a uniform source for several targets as targets from different sources

Return Tables using Transformation

Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle

Unit 9: InfoCube

DTP and its role in loading data to InfoCube in Extraction Mode

Real-Time Data Replication from Source system to BW and

Real-Time HANA Optimized InfoCubes

Understanding SAP HANA-Optimized Data Modeling: InfoCubes

Exercise 15: Get Acquainted with HANA-Optimized InfoCubes

Explaining SAP HANA-Optimized Data Modeling: Advanced DataStore-Objects

Exercise 16 Model Advanced DataStore-Objects

Unit 10: SLT Configuration, MultiProviders and Extractions

Steps for performing SLT Configuration

Explaining the three scenarios to implement in SLT

Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5

How are MultiProviders and InfoSets similar?

Mixed Models

ECC Extractions

Different Extractor types

Steps for Data Extraction method from Non-SAP Source Systems

ECC Extractor using Business Content Extractors for Accounts Receivable

Loading data for characteristics, Master data using Business Content Extractors

Explaining SAP HANA-Optimized Data Modeling: CompositeProviders

Exercise 17: Model Composite Providers

Explaining SAP HANA-Optimized InfoObjects

Exercise 18: Define a new InfoObject

Explaining SAP HANA-Optimized Data Staging

Exercise 19: Work with HANA-Optimized Transformation Rules

Unit11: Optimization Areas in BW on HANA

SAP HANA-Optimized Data Modeling: InfoCubes

SAP HANA-Optimized Data Modeling: Advanced DataStore-Objects

SAP HANA-Optimized Data Modeling: CompositeProviders

SAP HANA-Optimized Data Modeling: InfoObjects

SAP HANA-Optimized Data Staging

SAP HANA-Optimized Data Analytic Manager

SAP HANA-Optimized Analysis Processes

Describing the SAP HANA-Optimized Analytic Manager

Exercise 20: Get Acquainted with the Analytic Manager

Introducing HANA-Optimized Analysis Processes

Exercise 21: Create a HANA Analysis Process (HAP)

Unit12: Modelling with SAP’s Reference Architecture

LSA++

Review of Layered Scalable Architecture (LSA)

Explaining the Layered Scalable Architecture (LSA)

Explaining the Move from LSA to LSA++: Streamlining Core Layers

LSA++: Introducing the Open Operational Data Store Layer

From LSA to LSA++: Streamline Core Layers

LSA++: Open Operational Data Store Layer (Open ODS Views)

LSA++: Agile Data Mart & BW Workspace Layer

Modeling with SAP’s Reference Architecture LSA++

Exercise 22: Create an Open ODS View on HANA Table

Exercise 23: Create an Open ODS View on Remote Data

Exercise 24: Create an Open ODS View with Association to another one

Exercise 25: Create an Open ODS View referring to InfoObjects

Exercise 26: Create an Open ODS View on BW Transformation Rule

Exercise 27: Create an Open ODS View on Advanced DataStore- Object

LSA++: Introducing the SAP BW Workspace Layer

Exercise 28: Create a SAP BW Workspace

Exercise 29: Upload new Local Data into BW Workspace with MS Excel-lntegration

Exercise 30: Define a SAP BW Workspace Query with new Local Data

Exercise 31: Merge new local Data individually

Unit13: Hybrid Modeling in Mixed Scenarios

Merging Data from SAP BW and SAP HANA (Mixed Scenarios)

Generating SAP HANA Views from the BW System InfoProviders

Authorizations for SAP BW and SAP HANA (Mixed Scenarios)

HANA-Optimized BI Content

Generating External SAP HANA Views for SAP BW InfoProviders

Exercise 32: Create External SAP HANA Views

Describing Mixed Scenarios

Exercise 33: Implement a Mixed Scenario

Explaining SAP HANA-Optimized SAP Bl Content

Unit 14: BW Reporting

Introduction to BW Reporting - BEx Reporting Suit

Important Business Explorer Designers

BEx Query Navigation Options in WebQuery

Creating Key Figure at InfoProvider and query level

Unit15: Summary & Outlook

New Transactions and BW on HANA Road Map

The HANA Data Ware House.