BW on Hana


Business Warehouse on Hana

Category: Tag:


Business warehouse on hana

Course Content:

  1. Introduction to SAP HANA
  2. History of SAP HANA
  3. Overview of SAP HANA Studio
  4. SAP HANA Technology Innovations
  1. SAP HANA Architecture
  2. Index Server
  3. Persistence Layer
  1. Overview of Data Provision Methods
  2. Flat file Uploading
  3. How to get multidimensional Sales Report
  4. Overview of Business Objects Data Services using ETL-based approach
  1. Introduction to SAP HANA Information Models
  2. Analytical View for COPA Plan using Attribute views and COPA Actual
  3. How to use join operators in building Calculation view
  4. Methods to create Calculation view
  1. Overview of SAP BW  on HANA
  2. Data Warehousing Workbench
  1. Overview of InfoObjects
  2. Creating Characteristics under Catalog
  3. InfoObjects Characteristics and Key Figures
  4. Classification of Master Data
  5. Creating Characteristics
  6. Overview of Key Figures and Data Flow
    1. Overview of DataStore Objects
  7. How to load transactional data to DataStore Objects
  8. SAP HANA Optimized DSO
  9. Lookups on Active data DSO
  1. Explaining Transformations Framework and Expert Routines using Scenario based example
  2. Mapping One Source Field to Target Field
  3. Working with Expert Routines
  4. Writing Expert Routines Code in ABAP
  5. Introduction to InfoSource and Execution of two transformations before executing multiple transformations
  6. InfoSource as a uniform source for several targets as targets from different sources
  7. Return Tables using Transformation
  8. Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle
  1. DTP and its role in loading data to InfoCube in Extraction mode
  2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes
  1. Steps for performing SLT Configuration
  2. Explaining the three scenarios to implement in SLT
  3. Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5
  4. How are MultiProviders and InfoSets similar?
  5. Mixed Models
  6. ECC Extractions
  7. Different Extractor types
  8. Steps for Data Extraction method from Non-SAP Source systems
  9. ECC Extractor using Business Content Extractors for Accounts Receivable
  10. Loading data for characteristics, Master data using Business Content Extractors
  1. Introduction to BW Reporting – BEx Reporting Suit
  2. Important Business Explorer Designers
  3. BEx Query Navigation Options in WebQuery
  4. Creating KeyFigure at InfoProvider and query level