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 Info Objects
  • Creating Characteristics under Catalog
  • Info Objects 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.