Improve your SAP BW Backend Performance

Name: Improve your SAP BW Backend Performance
Rating: 3.4 (5 reviews)

Learn how to improve the performance of your daily loadings for your own or your customer's SAP BW system.

Created byNext Level ‾‾, Benjamin Meyer

Last updated 1/2015

English

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

Course content

8 sections • 26 lectures • 3h 0m total length

Introduction to layered architectures in BW5:58
This lecture provides a quick revisit to layered architectures and their building blocks.
Interrelations between layered architecture and processing time5:52
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.

Introduction to the identification of bottlenecks6:07
Realize through this lecture why the identification of bottlenecks is critically important for sustainable BW operations.
Making use of the BW Analysis & Service Tools Launchpad5:28
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 Application Analysis2:38
This lecture introduces to BW Application analysis details.
Identify bottlenecks through SAP BW Technical Content5:39
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.
SAP Solman Early Watch Alert2:56
In case you are using Solution Manager, take the EWA into consideration that you get introduced to in this lecture.

General strategies for BW performance optimization5:56
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.
Process chains, transformations and parallel processing capabilities10:55
Rethink process chains, trainsformations and parallel processing alltogether in terms of performance in this lecture.
Maintain parallelization settings in your system11:08
Take advantage of this lecture by revisiting and maintaining the parallelization parameters in your own system - after being given this brief introduction.
Improving of DSO performance (read/write)10:24
Revisit your DSO performance after being introduced to measures to optimize performance for Datastore reads and writes.
Improving InfoCube performance (read/write)10:55
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 master data performance (read/write)7:35
Revisit your master data loads after being introduced to levers for master data performance in this lecture.

Generic strategies to tackle upstream layer load performance4:06
Learn which generic strategies exist to make your upstream layers more efficient.
Delta capabilities of SAP Business Content DataSources9:41
A lot of SAP Business Content datasources provide delta capabilities. Besides others, learn how to identify them.
Delta capabilities of Generic DataSources3:25
Generic datasource are often necessary. The more important gets the requirement to speed them up. Learn how delta capable generic datasources support you.

Using ABAP Runtime analysis in a BW context9:13
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.
General rules to improve ABAP performance15:11
This lecture, among others, allows you to understand which table types are most efficient in your BW routines.
Tip for a quicker time measuring process of alternative ABAP code2:27
Learn how a split analysis view can make see benefits from alternative ABAP codings.

Introduction to dimensional modelling and BW Extended Star Schema revisit5:10
This lecture provides you the necessary recap and introduction to dimensional modelling to go through that section.
Dimensioning Matrix approach7:14
Get to know an approach to visualize optimization options that you can implement by a dedicated ABAP coding on top of your existing data.
Standardized and structured approach to optimize your InfoCube data model6:28
Which steps to take to optimize your data model? Grasp some suggestions here.
Real-World Example: Revisit sensitivity analysis and its improvements (II)4:32
Here you will be provided some number crunching again: this time with a focus on the data model dimensioning results.

Requirements

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

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.

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

Improve your SAP BW Backend Performance

What you'll learn

Explore related topics

Course content

Setting the context of layered architectures and performance2 lectures • 12min

Identification of bottlenecks5 lectures • 23min

Sensitivity analysis approach to optimize performance2 lectures • 18min

How to improve performance in selected BW layers6 lectures • 57min

Levers to improve performance in Upstream Layers3 lectures • 17min

Approaches to analyze and improve ABAP performance3 lectures • 27min

InfoCube data model quality and improvement approaches4 lectures • 23min

Final section1 lecture • 3min

Requirements

Description

Who this course is for: