Improve your SAP BW Backend Performance
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.
23 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Improve your SAP BW Backend Performance to your Wishlist.

Add to Wishlist

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.
23 students enrolled
Last updated 1/2015
Price: $95
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • 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 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
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
About the Instructor
Next Level  ‾‾
3.7 Average rating
3 Reviews
23 Students
1 Course
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.

Benjamin Meyer
3.7 Average rating
3 Reviews
23 Students
1 Course
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.