16. How to create a DTP and load data to the data target in SAP Business Intelligence (BI / BW)

A video demonstration / tutorial for How to create a DTP and load data to the data target in SAP Business Intelligence / Business Warehouse BI / BW A data transfer process (DTP) is an object that determines how data is transferred between two persistent objects in SAP NetWeaver BW. You use the data transfer process to transfer data within SAP NetWeaver BW from one persistent object to another object, in accordance with certain transformations and filters. In this respect, it replaces the data mart interface and the InfoPackage. As of SAP NetWeaver 7.0, the InfoPackage only loads data to the entry layer of BW (PSA). The data transfer process makes the transfer processes in the data warehousing layer more transparent. Optimized parallel processing improves the performance of the transfer process (the data transfer process determines the processing mode). You can use the data transfer process to separate delta processes for different targets and you can use filter options between the persistent objects on various levels. For example, you can use filters between a DataStore object and an InfoCube. Data transfer processes are used for standard data transfer, for real-time data acquisition, and for accessing data directly. - A DTP can be created at the data source or data target level - Right click data source - Click create data transfer process - Shows the source and target - check settings - Select continue - Extraction - Where extracting - Execute - Disabled to enable activate ctrl+F3 the data transfer process - Click execute - Push data to target If all green - Click administer data targets - Select table - Click contents - select execute F8