VirtualProviders Based on the Data Transfer Process 

Definition

VirtualProviders whose transaction data for reporting is read directly from an SAP system via a DataSource or an InfoProvider.

Use

Use this VirtualProvider if

·        You need very up-to-date data from an SAP source system

·        You only access a small amount of data from time to time

·        Only a few users execute queries simultaneously on the database.

Do not use this VirtualProvider if

·        You request a large amount of data in the first query navigation step, and no appropriate aggregates are available in the source system

·        A lot of users execute queries simultaneously

·        You frequently access the same data

Structure

This type of VirtualProvider is defined based on a DataSource or an InfoProvider and takes on its characteristics and key figures. Master data and hierarchies are not read directly in the source system. They are already replicated in the BI system when you execute a query.

The transaction data is called during execution of a query in the source system. During this process, the selections are provided to the InfoObjects if the transformation is only simple mapping of the InfoObject . If you have specified a constant in the transformation rules, the data is transferred only if this constant can be fulfilled. With more complex transformations such as routines or formulas, the selections cannot be transferred. It takes longer to read the data in the source system because the amount of data is not limited. To prevent this you can create an inversion routine for every transfer routine. Inversion is not possible with formulas, which is why SAP recommends that you use formulas instead of routines.

See also:

Creating VirtualProviders Based on DataSources/InfoProviders