Show TOC

Background documentationStructure of HybridProviders Based on Direct Access Locate this document in the navigation structure

 

The HybridProvider on direct access is based on a combination of VirtualProvider and InfoCube. Both objects have the same structure. When you edit the HybridProvider, you edit both InfoProviders in the same way.

The data is loaded using a data transfer process that you create from the InfoCube of the DataSource. The system also creates a data transfer process between VirtualProvider and DataSource, that uses the same transformation.

The graphic below shows the data flow in a HybridProvider based on direct access:

This graphic is explained in the accompanying text.

When the query is executed on the HybridProvider, most of the data is read from the InfoCube. The most up to date data is also read from the source system using the VirtualProvider. Only the data that has not been loaded into the InfoCube is read. In BEx Query Designer, go to   Properties   Advanced   and set the request status Hybrid Delta.

The request status Hybrid Delta is not supported by all DataSources that can be connected to a HybridProvider however. In other words, you cannot always read the most up to date data from the source system due to technical reasons. However the use of a HybridProvider based on a direct access is still recommended. In this case, use the request status Switch. This means that the data is read either from the InfoCube or from the VirtualProvider. Using a variable, you can control what data is read while the query is running.

With the HybridProvider based on direct access, you can only load data from a single DataSource. The DataSource must fulfill the following requirements (depending on the read mode being used):

  • Switch:

    The DataSource must support direct access.

  • Hybrid delta:

    • The DataSource must support direct access.

    • The DataSource must be a generic DataSource with generic delta and meet the following conditions:

      • You cannot maintain the lower safety interval due to the risk of duplicate data records.

      • The delta must be InfoCube-enabled.

      For more information on the generic delta, see Delta Transfer Settings.

    • The source system of the DataSource must have PI_BASIS 7.02 or higher.