Select Data in DTP Dynamically

Similarly to selecting parameters dynamically in the infopackage, as discussed in the previous post, we may need to select parameters dynamically in a DTP. In the post below I will review an example of how to make selections dynamically in the DTP. A practical application of this approach can be selection of records from a DSO by date range, say we want to select all records with Date From lower than [Today + 30 days] and Date To greater than [Today - 30 days].

In the Filter selections for the DTP we have to click on the “Routine create” button for the infoobject we want to use:

As DTP selections are stored as a range we have to populate fields of the table l_t_range with appropriate selection parameters.

Making Error DTP Work for DSO‘s

Link to Article

What is Direct DTP and RDA DTP?

We use the data transfer process (DTP) to transfer data from source objects to target objects in BI. 

We can also use the data transfer process to access InfoProvider data directly.

Direct DTP: You use a data transfer process for direct access to access the data in an InfoProvider directly.

RDA DTP: You use the data transfer process (DTP) for real-time data acquisition to transfer data to the DataStore objec*t from the PSA.* In the DataStore object, the data is available for use in reporting.

In the following business scenario, we will use them:

Direct DTP: Normally for the Reporting based on Historical Data/Current Data.

RDA DTP: Each and Every Hourly Reporting like Share Markets, Hourly changing DATA situations

Can we load master data through RDA DTP?

No. 

RDA is basically used from Transaction data and not all the Data sources are enabled for RDA.

To find whether a data source supports RDA, you can check in the table ROOSOURCE (Field REALTIME = 'X'),

what are the difference B/W loading data using SAP API and Web services. we generally use SAP API for SAP source system and for other Web services. I am i right?

Yes.

Webservices are used to Push the data to BI from the Webservice based messaging systems (Middleware like XI, TIBCO Etc).
Where as Service API (SAPI) is used to Pull the data from SAP Source systems to BI.

Creating Data Transfer Processes for Direct Access

Use

We use a data transfer process for direct access to access the data in an InfoProvider directly.

Prerequisites

You have used transformations to define the data flow between the source and target object.

Procedure

Simulating and Debugging DTP Requests

Use

Simulating the data update and debugging a data transfer process request (DTP request) help you to analyze an incorrect DTP request. 

In this way we can also simulate a transformation prior to the actual data transfer if we would like to check whether it provides the desired results.

Procedure

Simple Simulation and Debugging..

       1.      If we want to execute a standard DTP in debug mode, choose Serially in the Dialog Process (for Debugging) as the processing mode on the Execute tab page in the DTP maintenance. 

DTP(Data Transfer Process) - 2

Data transfer process is new comes with SAP BI 7.0. Using Data transfer process 
we can improve the loading process, filtering, error handling etc. 

Data transfer process (DTP) loads data within BI from one object to another object
with respect to transformations and filters. DTP is used to load the data from 
Persistent Staging Area (PSA) to data targets.

Data transfer process (DTP) loads data within BI from one object to another object with respect to transformations and filters. 

DTP(Data Transfer Process) - 1

Definition

Object that determines how data is transferred between two persistent objects.

Use

We use the data transfer process (DTP) to transfer data within BI 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 BI (PSA).

Processing Modes of Data Transfer Processes

Link to Article

Load Master Data to InfoProviders Straight from Source Systems

In data transfer process (DTP) maintenance, you can specify that data is not extracted from the PSA of the DataSource but is requested straight from the data source at DTP runtime.  

The Do not extract from PSA but allow direct access to data source indicator is displayed for the Full extraction mode if the source of the DTP is a DataSource. 

We recommend that you only use this indicator for small datasets; small sets of master data, in particular.

Extraction is based on synchronous direct access to the DataSource.

Creating Data Transfer Processes

Use

We use the data transfer process (DTP) to transfer data from source objects to target objects in BI. 

We can also use the data transfer process to access InfoProvider data directly. 

Prerequisites

We have used transformations to define the data flow between the source and target object.

Procedure

Three Ways to Dynamically Update “Data Transfer Process” Filter Values Applies

Link to Article

Why DTP and not IP in SAP BI 7.0

Link to Article