BW Operations and Performance

Course Details
Code: BW360-v010
Tuition (USD): $4,090.00 • Virtual (5 days)
$4,090.00 • Classroom (5 days)
Course Details
GSA (USD): $3,037.78 • Virtual (5 days)
$3,037.78 • Classroom (5 days)

Skills Gained

  • Acquire extended knowledge and skills in SAP BW Operations
  • Acquire extended knowledge and skills in SAP BW Perfomance Optimization

Who Can Benefit

  • Database Administrator
  • Solution Architect
  • Technology Consultant

Prerequisites

  • Essential:
       -BW310
       -Extensive SAP Data Warehousing Experience"
  • Recommended:
       -Experience with SAP BW
       -Data Base Basics Experience
       -Data Dictionary Experience

Course Details

Course Content

  • An Overview of SAP NetWeaver Business Warehouse (BW), BW Accelerator, and SAP HANA
       -Identifying the Components and architecture of SAP NetWeaver BW, BW Accelerator, and SAP HANA
  • InfoProvider Administration
       -Managing InfoCubes
       -Managing DataStore Objects
       -Managing MultiProviders
       -Managing HybridProviders
       -Managing Semantically Partitioned Objects (SPOs)
       -Managing TransientProviders
       -Managing Analytical Indexes
       -Managing VirtualProviders
       -Managing Real-Time Providers
       -Creating a DataStore Object for Direct Update
  • Process Chain Administration
       -Designing Process Chains
       -Maintaining Process Chains
       - Monitoring Process Chains
  • Data Acquisition Administration
       -Describing the Data Load Cycle
       -Examining the Technical Details of Data Loading
       -Loading Master Data
       -Using Transformations
       -Monitoring Data Load
  • Working with the BW Trace Tool
       -Working with the BW Trace Tool
  • Information Lifecycle Management
       -Classic Archiving in Information Lifecycle Management
       -Making Archived Data Available for Queries Using BW Near-Line Storage
  • BW Transports
       -Describing the BW Transport System Landscape
       -Determining Object Versions and Metadata
       -Managing BW Transports
       -Transporting BEx Objects
       -Transporting Roles and Workbooks
       -Investigating Transport Strategies and Troubleshooting
  • Performance Management with BW InfoProvider Indexes
       -Determining Relational DBMS Indexes
       -Indexing for InfoProviders
  • Optimizing Performance for InfoProviders
       -Optimizing Performance for DataStore Objects
       -Optimizing Performance for InfoCubes
       -Optimizing Performance Using Semantically Partitioned Objects
       -Optimizing Performance Using Analytical Indexes
       -Optimizing Performance Using TransientProviders
       -Working with Aggregates
       -Optimizing Performance Using MultiProviders
       -Optimizing Performance Using HybridProviders
  • Optimizing Data Acquisition Performance
       -Configuring Data Acquisition Parallel Processing
       -Improving Data Acquisition Performance
       -Loading and Activating DataStore Objects
  • Performance Through Partitioning
       -Performing Table Partitioning
  • Reporting Performance
       -Designing Queries for Optimal Performance
       -OLAP Caching
       -Maintaining Query Properties
  • Managing Performance with BW Statistics
       -Getting an Overview of BW Statistics
       -Implementing Technical Content for BW Statistics
       -Administering and Analyzing BW Statistics Data
       -Monitoring with BW Administration Cockpit and BO Dashboard
  • Performance Management with BW Accelerator
       -Performance Optimization with BW Accelerator
       -Determining BW Accelerator Architecture
       -Increasing Query Read Performance Using BW Accelerator Indexes
       -Monitoring BW Accelerator
       -Envisioning the Future of SAP HANA with BW

Notes

  • This course does not discuss SAP BW with HANA in depth. For more information about SAP BW with HANA, see BW362.

Course based on software release

  • SAP NetWeaver BW 7.4