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.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
20 students enrolled
Take This Course
  • Lectures 26
  • Length 3 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English

Course Description

*** 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.

What are the requirements?

  • Basic to advanced know-how in BW modelling
  • Know-how in ABAP modelling (for related sections)

What am I going to get from this course?

  • 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

Who is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Setting the context of layered architectures and performance

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


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.

Section 2: Identification of bottlenecks

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


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


This lecture introduces to BW Application analysis details.


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.


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

Section 3: Sensitivity analysis approach to optimize performance

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.


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

Section 4: How to improve performance in selected BW layers

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.


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


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


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


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.


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

Section 5: Levers to improve performance in Upstream Layers

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


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


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

Section 6: Approaches to analyze and improve ABAP performance

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.


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


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

Section 7: InfoCube data model quality and improvement approaches

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


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


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


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

Section 8: Final section

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Next Level ‾‾, Level up your knowledge.

Next Level ‾‾ offers valuable educational experiences presented by anxious and certified instructors.

Our unique training experiences are based on the mix of high quality instructors and best practice curricula:

Each instructor earned credit by more than 1000+ hours of real life, that is offline course, instruction in professional business settings. Furthermore, our instructors typically act as renowned speakers at related conferences in the EU as well as the US.

Each curriculum is a result of our instructors' comprehensive experience. It is tailored to the specific needs of the learners and combines valuable practical and theoretical information.

Next Level ‾‾ believes in content quality as well as delivery quality, both as means to make the learner have a great learning experience supported by great audio and video.

Instructor Biography

Benjamin Meyer, BW Senior Consultant

Benjamin is a seasoned SAP BW professional and has been working with SAP's Business Intelligence solution for more than 8 years. He is proficient in SAP BW versions 3.5 to 7.4 including BW on HANA. Originally from Switzerland he has travelled extensively in the german speaking countries (D-A-CH). Ben frequently conceptualizes and/or records virtual as well as real training sessions.

Ready to start learning?
Take This Course