Show TOC

Screen Area "Extended"Locate this document in the navigation structure

Under Extended in the General tab, you can make data integrity settings. These are relevant if your back-end system supports this.

Request-Status

If the InfoProvider is suitable for this, you can specify how recent the displayed InfoProvider data is. In an InfoCube, the system can read data with different request statuses. The following request statuses are possible:

  • Green: Request loaded successfully

  • Yellow: Request not loaded successfully (still loading)

  • Red: Request not loaded successfully

The system supports the following alternatives for InfoProvider data integrity:

Table 1: Options for Specifying Data Integrity

Option

Description

All InfoProviders up to released status (RQTS0): All InfoProviders Up to Released Status (RQTS0) (0)

The system reads all data up to the first open request or request with errors. This is the default setting for queries.

Real-time InfoCubes up to current version: Real-Time InfoCubes up to Current Version (1)

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

Note

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

All InfoProviders up to current version (to Qualok): All InfoProviders Up to Current Version (to Qualok) (2)

In addition to the All InfoProviders up to released status (RQTS0) mode, the system also reads the data up to and including the first open request for all InfoProviders.

All InfoProviders up to current version (all green requests): 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.

Every InfoProvider in MultiProvider according to its setting: Every InfoProvider in the MultiProvider according to its setting (7)

The system reads the data from all InfoProviders of a MultiProvider according to their request statuses. This setting is only possible for MultiProviders.

All InfoProviders (including red requests): All InfoProviders Complete (Red Requests as Well) (9)

The system reads all available data; all incorrect requests and all open requests for a query are included.

If you do not want to select a particular request status, you can also define a variable.

Near-Line Storage

If the query is based on an InfoProvider that data has already been stored for in a near-line storage, you can stipulate that the stored data is read and displayed when the query is run.

Table 2: Near-Line Access Options

Option

Description

Use Near-Line Storage According to Basic Provider Setting: Near-line access is made in accordance with the InfoProvider setting.

This option is only relevant for a MultiProvider. If this option is activated, the setting for each individual InfoProvider in the MultiProvider comes into effect.

Do Not Read Near-Line Storage: Near-line access is deactivated.

The query does not access the data, even if the data has been stored in a near-line storage. A setting in an InfoProvider (contained in a MultiProvider) that allows this access to occur overwrites these settings.

Note

If you have deactivated access in the InfoProvider settings, you cannot activate it again in the query properties.

Read Near-Line Storage: Near-line access is activated.

Access to data in a near-line storage is possible if one of the following conditions are met:

  • There is a data archiving process for the InfoProvider.

  • This process is connected with a near-line storage.

  • The selection conditions of the navigation step intersect with the previously archived data area.

This setting allows access to all the InfoProviders in a MultiProvider that fulfill predefined conditions (even if access is deactivated in an InfoProvider).

You can also define a variable for near-line access.

Document Links for:

If you select the corresponding setting, the system displays links to documents - provided that you have created the documents for the InfoProvider data, master data or metadata of the query.