Show TOC

Structure of HybridProviders Based on Direct AccessLocate 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 for direct access between VirtualProvider and DataSource, which uses the same transformation. Note that the filter and semantic groups (of the data transfer process that you created) are ignored for direct access. More information: Creating Data Transfer Processes for Direct Access

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

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. To this you have to set one of the following request statuses under Start of the navigation path Settings Next navigation step Advanced End of the navigation path in BEx Query Designer or in the InfoProvider properties:

  • 2 All InfoProviders Up to Current Version (to Qualok)
  • 3 All InfoProviders Up to Current Version (All Green Requests)

If you set the following request status, only the delta from the VirtualProvider will be read:

  • 9 All InfoProviders Complete (Red Requests as Well)

These request statuses are 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. Using a HybridProvider based on direct access is still recommended however. You can then read the data by Switch. This means that the data is read either from the InfoCube or from the VirtualProvider. To do this, you have to define a variable of your own, which references 0ACTUALDTA. You can use this variable at runtime to define whether to read Standard (from the InfoCube) or read current data (from VirtualProviders).

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.

  • All InfoProviders Up to Current Version:

    • The DataSource must support direct access.

    • The DataSource must be a generic DataSource with generic delta and must also 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.