Improve your SAP BW Backend Performance
3.5 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled

Improve your SAP BW Backend Performance

Learn how to improve the performance of your daily loadings for your own or your customer's SAP BW system.
3.5 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled
Last updated 1/2015
English [Auto-generated]
Price: $94.99
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn how a BW layer architecture and ETL performance relate to each other
  • Examine approaches to identify bottlenecks and optimize a BW landscape in a structured and targeted manner
  • Take a look at the central BW objects constituting an efficient layered architecture and explore practices to improve data loading, i.e. read and write access for them
  • Examine the importance of the quality of a dimensional model and an approach to improve it
  • Basic to advanced know-how in BW modelling
  • Know-how in ABAP modelling (for related sections)

*** Limited Time Offer - ask us for a special discount! ***

This course introduces to important principles to improve performance of your nightly loading processes in BW. You will be able to understand typical shortcomings in data models.

To achieve this, it covers optimization approaches for the most important data target types in BW. In addition,it introduces improvement approaches for upstream layers and provides valuable tips for ABAP optimizations related in the BW domain.

You should expect this course to be your companion for your very own journey in your own BW system. Learn the principles and approaches and use them in your own system right away!

At the end of this course you will be able to take your BW operations to the next level performance-wise.

Who this course is for:
  • Students that want to improve their data loading performance in traditional stack RDBMS BW landscapes
  • Students that want to learn structured approaches to identify bottlenecks and create options to improve their system
  • Students that need urgently solutions to improve their loading performance
Course content
Expand all 26 lectures 03:00:19
+ Setting the context of layered architectures and performance
2 lectures 11:50

This lecture provides a quick revisit to layered architectures and their building blocks.

Preview 05:58

There exist interrelations between your layered architecture and performance during periodic dataloads, i.e. backend performance. In this lecture, learn how those interrelations are characterized.

Preview 05:52
+ Identification of bottlenecks
5 lectures 22:48

Realize through this lecture why the identification of bottlenecks is critically important for sustainable BW operations.

Introduction to the identification of bottlenecks

The launchpad introduced can help you to jump start into diagnosis right now. Try it. If you were aware of already - revisit it again.

Making use of the BW Analysis & Service Tools Launchpad

This lecture introduces to BW Application analysis details.

Making use of the BW Application Analysis

Get introduced to BW Technical Content in this lecture and check whether it is implemented in your system right away. If so, try to use the queries introduced to.

Identify bottlenecks through SAP BW Technical Content

In case you are using Solution Manager, take the EWA into consideration that you get introduced to in this lecture.

SAP Solman Early Watch Alert
+ Sensitivity analysis approach to optimize performance
2 lectures 18:09

The results of your very own sensitivity analysis will be a huge win and can optimize current as well as future performance issues. Learn how to tacke such an analysis here.

Introduction to sensitivity analysis

Close this lecture with some important tips and tricks for your analyses.

Tips & tricks for post-conduction of sensitivity analyses
+ How to improve performance in selected BW layers
6 lectures 56:53

There do exist strategies that may help you along your way with your very own performance issues. Get introduced to some real world strategies that you can re-use or extend.

General strategies for BW performance optimization

Rethink process chains, trainsformations and parallel processing alltogether in terms of performance in this lecture.

Process chains, transformations and parallel processing capabilities

Take advantage of this lecture by revisiting and maintaining the parallelization parameters in your own system - after being given this brief introduction.

Maintain parallelization settings in your system

Revisit your DSO performance after being introduced to measures to optimize performance for Datastore reads and writes.

Improving of DSO performance (read/write)

Revisit your infocube loads after being introduced to levers for infocube read / write performance in this lecture. In addition, dimensional models of infocubes will also be revisited in a later section.

Improving InfoCube performance (read/write)

Revisit your master data loads after being introduced to levers for master data performance in this lecture.

Improving master data performance (read/write)
+ Levers to improve performance in Upstream Layers
3 lectures 17:12

Learn which generic strategies exist to make your upstream layers more efficient.

Generic strategies to tackle upstream layer load performance

A lot of SAP Business Content datasources provide delta capabilities. Besides others, learn how to identify them.

Delta capabilities of SAP Business Content DataSources

Generic datasource are often necessary. The more important gets the requirement to speed them up. Learn how delta capable generic datasources support you.

Delta capabilities of Generic DataSources
+ Approaches to analyze and improve ABAP performance
3 lectures 26:51

Having an understanding for which parts of your codings are less efficient than others should be one of your primary goals. In this lecture, learn how runtime analysis can support you.

Using ABAP Runtime analysis in a BW context

This lecture, among others, allows you to understand which table types are most efficient in your BW routines.

General rules to improve ABAP performance

Learn how a split analysis view can make see benefits from alternative ABAP codings.

Tip for a quicker time measuring process of alternative ABAP code
+ InfoCube data model quality and improvement approaches
4 lectures 23:24

This lecture provides you the necessary recap and introduction to dimensional modelling to go through that section.

Introduction to dimensional modelling and BW Extended Star Schema revisit

Get to know an approach to visualize optimization options that you can implement by a dedicated ABAP coding on top of your existing data.

Dimensioning Matrix approach

Which steps to take to optimize your data model? Grasp some suggestions here.

Standardized and structured approach to optimize your InfoCube data model

Here you will be provided some number crunching again: this time with a focus on the data model dimensioning results.

Real-World Example: Revisit sensitivity analysis and its improvements (II)
+ Final section
1 lecture 03:12

This lecture provides the most important take aways of this class. Do not miss it!

7 Key Points to take away