Applies to: SAP BW 7.4
Summary: This document describes the enhancements to DTPs(Data Transfer Process) in SAP BW 7.4.
Author: Sudeepti Bandi
Company: NTT DATA Global Delivery Services Limited
Created On: 26th May 2015
Author Bio
Sudeepti is a Principal Consultant at NTT DATA from the SAP Analytics Practice.
INTRODUCTION : SAP Netweaver BW 7.4 utilizes the SAP HANA as an underlying database. So, the enhancements in this version are built around the integration between SAP BW and SAP HANA. This blog is an attempt to demonstrate the new features available in SAP BW 7.4 DTPs. DTP's are used to transfer data from different sources of data to target objects.
Following are the options available in different tabs of Data Transfer Process(DTP) in SAP BW 7.4
A query (QueryProvider) can be used as the source object in a DTP.
Error handling has new descriptions.
The table below has a comparison of error handling options for DTP between SAP BW 7.4 and the prior versions.
The option ‘Track Records after Failed Request’ can be selected when error handling is set to ‘Terminate request; no record tracing; no updating’, i.e. when error handling is deactivated. By choosing this we can enable tracing of erroneous records after a request fails. This setting (deactivating error handling) helps performance of data load as there is no tracking of error records during data load process.
The DTP in 7.4 has a new processing mode – SAP HANA Processing. If the BW system is using HANA DB, this mode is seen in the DTP. We check for the availability of this processing mode by clicking on the button.
If the corresponding transformations can be processed in HANA DB, this option can be used provided the prerequisites listed below are met.
Prerequisites:
If the requirements listed above are not met, check availability throws an error as seen below.
Delta Merge: There are two storages when HANA DB is used - the main storage and the delta storage (delta index). Changes to data are saved in the delta index.. When a read access happens (example- a query being executed), both the main storage and delta storage are read and the results are merged. These changes are updated to main storage through a delta merge. Only when a threshold value is reached, the delta merge is triggered.
The checkbox ‘Trigger Database Merge’ in the ‘Update’ tab of the DTP is selected to enable the delta merge after the data load happens. In case of multiple sources to the object, delta merge has to be performed as a step in process chain called ‘Trigger for database merge’ to avoid any inconsistency in load balancing.
Conclusion:
This document is an attempt to highlight the enhancements to DTPs in SAP BW 7.4, by giving a look and feel of the new features. Please note that all the options were not explored to the fullest extent and there could be extension to few concepts and features mentioned here.
Reference Links:
http://scn.sap.com/docs/DOC-53527
http://help.sap.com/saphelp_nw74/helpdata/en/15/c4421e20e540b58cb7debe8656364d/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |