Specifying Data Integrity According to the Request Status 

Use

Using the Request Status setting, you can select how recent the data for an InfoProvider is to be when displayed.

This setting is applied to all InfoCubes and VirtualProviders that have implemented interface IF_RSD_DELTACACHE_SUPPORT and to all MultiProviders that contain the corresponding InfoCubes or VirtualProviders. For other InfoProviders (such as DataStore objects, master data, and InfoSets), the values of this field have the same effect.

This property consolidates and replaces the variables 0S_RQMRC, 0S_RQTRA and 0S_RQALL.

Prerequisites

In an InfoCube, the system can read data with different request statuses. You make this setting in the context menu of the rows in the table view of the InfoCube. The following request statuses exist:

●      Green: Request loaded successfully

●      Yellow: Request not loaded successfully (still loading)

●      Red: Request not loaded successfully

Procedure

Assuming the option is supported for the InfoProvider, you select the required setting for the Request Status option in the query properties.

The following options are supported for the data integrity of an InfoProvider:

...

●      All InfoProviders Up to Released Status (RQTS0) (0)

The system reads all data rolled up to the BI accelerator index or the aggregates. If there is no BI accelerator index or if there are no aggregates, all data up to the first erroneous or open request is used. This is the default setting for queries.

●      Real-Time InfoCubes up to Current Version (1)

In addition to the All InfoProviders up to Securely Accessible Status (RQTS0), for real-time InfoCubes, the system also reads the data up to and including the first open request.

The setting Real-Time InfoCubes up to Current Version should be used for queries based on a MultiProvider that contains the plan data in a real-time InfoCube and the actual data in a standard InfoCube.

●      All InfoProviders Up to Current Version (to Qualok) (2)

The system also reads those requests for an InfoCube with aggregates that are not yet rolled up, as long as they are from before the first erroneous request.

●      All InfoProviders Up to Current Version (All Green Requests) (3)

The system reads all requests that have no errors (all green requests); this includes requests created after requests with errors or requests that were not completed.

●      All InfoProviders Complete (Red Requests as Well) (9)

The system reads all available data, that is, all erroneous and all open requests for a query are included.

Data integrity "0" offers the best performance. In all other modes, the data from aggregates and data that is not yet rolled up is read from the fact tables of the InfoCube.