SAP BW-Transformations Part 2 скачать в хорошем качестве

SAP BW-Transformations Part 2

n SAP BW, transformations are objects that map and modify data from a source to a target. The first part of a transformation involves defining these mappings, where you can set up direct assignments or use routines for more complex logic. For SAP BW/4HANA, a new HANA-based runtime can be selected to push transformation logic into the SAP HANA database for better performance, which requires re-writing any custom ABAP logic into SQLScript. Creating a transformation Define the mapping: Transformations connect source and target fields. You can do this by creating rules that map fields and transform their content. Use direct assignment: The simplest rule is a direct assignment (e.g., an equals sign), which is used when no modification is needed and data can be passed directly from the source to the target. Use routines: For more complex transformations, you can use routines, which are defined at the individual field level. You access these by double-clicking or right-clicking a field in the transformation rule editor. Consider the runtime: The runtime status indicates whether a transformation can use the standard ABAP runtime or the more performant HANA runtime. HANA-based transformations (for performance) Leverage HANA runtime: With SAP BW on HANA, you can use the HANA runtime for transformations to execute the logic within the database itself, avoiding redundant data transfers between the database and application layers. Convert ABAP routines: Custom ABAP logic in standard transformations cannot be pushed down to HANA and must be converted to SQLScript. Use AMDP scripts: To benefit from HANA pushdown, create an ABAP Managed Database Procedure (AMDP) script for your routine instead of an ABAP routine. Develop SQL skills: Converting complex ABAP routines requires developing SQL skills and can be more challenging than ABAP programming. Use standard formulas: Where possible, use standard formulas instead of routines to leverage HANA pushdown automatically.