SAP BW ON HANA

SAP BW ON HANA Course Content

Unit 1: Introduction to SAP HANA Studio

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

Unit 2: SAP HANA Architecture

• SAP HANA Architecture
• Index Server
• Persistence Layer

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

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

Unit 6: InfoObjects and DataStore 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
  1. Overview of DataStore Objects
• How to load transactional data to DataStore Objects
• SAP HANA Optimized DSO
• Lookups on Active data DSO

Unit 7: SAP HANA InfoSource 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 8: 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

Unit 9: 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

Unit 10: BW Reporting

• Introduction to BW Reporting – BEx Reporting Suit
• Important Business Explorer Designers
• BEx Query Navigation Options in WebQuery
• Creating KeyFigure at InfoProvider and query level