Goals

  • Understand the Components and Architecture of SAP BW and SAP HANA
  • Create and Manage CompositeProviders and ADSO
  • Perform Delta Merge
  • Administer and Monitor Data Acquisition
  • Information Lifecycle Management
  • Manage SAP BW Transports
  • Manage SAP HANA Transports
  • Optimize Query Performance
  • Administer and Analyze BW Statistics
  • SAP HANA Administration for BW

Audience

  • Database Administrator
  • Enterprise Architect
  • Solution Architect
  • System Administrator
  • Technology Consultant

Prerequisites

Essential

Recommended

  • none

Course based on software release

  • SAP BW 7.5 powered by SAP HANA

Content

  • SAP Business Warehouse and SAP HANA Overview
    • Identifying the Components and Architecture of SAP BW and SAP HANA
  • InfoProvider Administration
    • Describing InfoProvider
    • Managing ADSO
    • Managing Open ODS View
    • Creating and Managing CompositeProviders
  • Delta Merge
    • Describing Delta Merge in BW
  • Data Acquisition Administration and Monitoring
    • Describing Data Acquisition Administration into SAP BW
    • Loading Master Data
    • Designing Process Chains
    • Maintaining Process Chains
    • Monitoring Process Chains
    • Using Transformations
    • Describing Data Aqusition in SAP HANA
  • Information Lifecycle Management
    • Describing Multi Temperature Data Management
    • Optimizing SAP BW Data Management (Warm Data)
    • Optimizing SAP BW Data Management (Cold Data)
  • SAP BW Transports
    • Describing the BW Transport System Landscape
    • Determining Object Versions and Metadata
    • Managing BW Transports
    • Transporting Query Objects
    • Troubleshooting Transport Strategies
  • SAP HANA Transports
    • Explaining SAP HANA Transports
  • Optimization Areas in SAP BW on SAP HANA
    • Describing HANA Optimized Data Modeling for InfoProviders
    • Improving Data Acquisition Performance
  • Performance in Reporting
    • Getting Acquainted with SAP HANA Analytic Manager
    • Designing Queries for Optimal Performance
    • Optimizing Query Performance Using the Online Analytical Processing (OLAP) Cache
  • Performance Management with BW Statistics
    • Optimizing Performance with BW Statistics
    • Implementing Technical Content for BW Statistics
    • Administering and Analyzing BW Statistics Data
    • Monitoring with BW Administration Cockpit
  • SAP HANA Administration for BW
    • Explaining Database Traces
    • Describing the DBA Cockpit
    • Analysing Memory Usage
    • Analyzing the Performance of SAP HANA Views
  • Additional topics for SAP BW on SAP HANA
    • Describing SAP HANA Data Warehousing Foundation
    • Explaining Solution Manager Configuration and Monitoring
    • Describing BW Housekeeping Tasks
    • Describing BW/4HANA
    • Performing Traces with BW Trace Tool