Business Warehouse Developers need to model and develop many complex data flows and queries. Learn ABAP to add an indispensable tool into your toolset and to solve complex problems in the most important areas of BW like transformation, DTP, InfoPackage, and query variables. Besides learning ABAP syntax, you will also gain insight into a programming style that keeps the performance, maintainability, and readability in focus.
Laszlo is an official certified SAP BW/BI consultant and trainer with over 10 years of IT experience.
He specializes in SAP Business Warehouse/Business Intelligence but also enthusiastic about other solutions like ABAP, C# and new software practices.
Improve Performance with Start Routine Hi, my name is Laszlo Meszaros from Pluralsight and welcome to this module about Improve Performance with Start Routine. In mid-size to large size data warehouses, the volume of the data might grow significantly day-by-day. The growing data volume, causes performance problems in a transformation in cases when there are many database selections during the data hold. In a growing data warehouse, it matters how many times our transformation hits the database because this increases the execution and the total loading time. The loading time becomes a very important factor that shows the hat of our system and the availability of the data so optimizing the loading time is a very important task. Optimization is more efficient when we do it already during the modeling of our transformation. Fortunately, we have tools for performance improvement in a transformation. In this module, I am going to show you the role of the start routine and it's important in performance optimization. When the loading time becomes crucial, start routine is an efficient tool to control the number of databases directions and to find a balance between the database and in-memory operations. For in the memory operations I will be also discussing the usage of the internal tables in ABAP that helps us to implement our balancing strategy. Let's see now how start routine and internal tables and reach our ABAP toolset in BW.
Improve Reusability with End Routine Hi, my name is Laszlo Meszaros from Pluralsight and welcome to this module about Improve Reusability with End Routine. Although our ABAP toolset with the start routine and filter rules is almost complete for solving complex problems, there are situations when we need more service from the BW transformation. As you can see on this example, we can easily face with the following business complexity. It might happen that we need to calculate several target fields with very similar logic. All of the fields share a common logic, but they are not the same because the logic varies a bit from target field to target field. If we implement such a logic in the field level rules, the common part will be repeated that results in a code duplication and time maintenance. In this module, I am going to show you an efficient technique for avoiding such a situation with the help of the end routine. You will see that the end routine is very good for separating the responsibilities by instructing a common logic into a separate partial target field in the field level rule and we will be able to reuse this logic in several target fields. The end routine can be the place where we can deal with the variations and fill the target fields in one step that improves the code reusability. Improve and reuse, how can we implement this? Join me, and I will show you.
ABAP in DTP and Infopackage Hi, my name is Laszlo Meszaros from Pluralsight and welcome to this module about ABAP in DTP and Infopackage. Data transfer processes and infopackages are the most used Runtime objects in BW. Both serve as a job for running our data flow. Since infopackages are responsible for the data extraction, data transfer processes load the data between the data source and the data target using the transformation that we defined at the modeling phase. During our extraction and load, we can apply field task to restate the data amount. In most of the cases, these filters are fixed values, but we might need dynamic filtering as well based on the rule. The typically dynamic filter scenario can be a pseudo data extraction with an infopackage then we extract data with a full method, but with a changing filter mimicking the data extraction mode. ABAP extends the functionality of the infopackage and the DTP by giving the possibility to apply a custom logic for dynamic filtering. In case of file based data sources, we might face with many files to be uploaded into BW. The file names file a typical naming convention with the changing part like the data of the upload. We can use the ABAP routine for dynamic files names in order that we can atomize our data load. Both dynamic filter and file names are great ABAP extensions of the Runtime objects that I want to show you in this module.
ABAP in Query Variables Hi, my name is Laszlo Meszaros from Pluralsight and welcome to this module about ABAP in Query Variables. Being an efficient and flexible reporting system, many users run queries in the business warehouse. An analyst needs to run different queries in different scenarios by filling many variable screens. The reporting user works a lot with query variable because this is the first screen that appears for them. Having many variable to fill, can become a time consuming task and uncomfortable. In this module, I am going to discuss how we can use ABAP to improve the user satisfaction and the acceptance of the BW system as a flexible reporting tool. We can ride customer exits in reporting that are widely used to help the query users to fill the variable screens faster and in a consistent way. What are exactly customer exits and how to use them for query variables? This is what I am going to show you now.