SAP BW (Business Warehouse) on HANA

Introduction to SAP HANA Studio

• Introduction to SAP HANA
• History of SAP HANA
• Overview of SAP HANA Studio
• SAP HANA Technology Innovations

SAP HANA Architecture

• SAP HANA Architecture
• Index Server
• Persistence Layer

Data Provision Methods

• Overview of Data Provision Method
• Flat file Uploading
• How to get multidimensional Sales Report
• Overview of Business Objects Data Services using ETL-based approach

HANA Information Model

• Introduction to SAP HANA Information Model
• 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

Overview of SAP BW on HANA

• Overview of SAP BW on HANA
• Data Warehousing Workbench

 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 DataStore Objects
• How to load transactional data to DataStore Objects
• SAP HANA Optimized DSO
• Lookups on Active data DSO

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

 Info Cube

• 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

SLT Configuration, Multi Providers and Extractions

• Steps for performing SLT Configuration
• Explaining the three scenarios to implement in SLT
• Introduction to Multi Provider and Creating Multi Provider in SAP BW
• How are Multi Providers and Info Sets 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

BW Reporting

• Introduction to BW Reporting - BEx Reporting Suit
• Important Business Explorer Designers
• BEx Query Navigation Options in WebQuery
• Creating Key Figure at Info Provider and query level

Eligibility / Requirements

Pre-requisites

• Candidates should have basic knowledge of data warehousing concepts along with excellent business knowledge on different application areas.
• Experience in the ABAP language will be an added advantage.
• Materials provided: SQL Tutorial, Data Modeling and DW concepts