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
• 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.