Show TOC

Processing Selection ConditionsLocate this document in the navigation structure

Use

In the context menu of the VirtualProvider, you choose the Display Data function. The system may display more data records than were actually selected. This depends on the processing type for the selection conditions on the characteristic. The Display Data function is only intended as a technical display; the system does not perform filtering. This can cause data records to appear in the display that are not selected by the selection conditions specified on the selection screen.

However, the correct result is displayed in the query. Surplus data records are filtered out again in the analytic manager after transformation.

Cause

For a VirtualProvider based on a data transfer process for direct access, there is always a transformation in the data flow between the source and the target (the VirtualProvider). Whether the selection conditions at the target can be passed back in full to the source using an inverse transformation depends on the complexity of the transformation. If it is not possible to pass back the exact selection conditions to the source, the selection conditions are simplified. This ensures that no data records in the source that correspond to the selection conditions after transformation are missed. In extreme cases this may mean that all data records are read from the source.

It may not be possible to pass back the selection conditions for a characteristic in the VirtualProvider to the source for the following reasons:

  • The transformation consists of an expert routine or contains a start or end routine.

  • The characteristic is filled using a rule of rule type Formula, Routine or Read Master Data.

  • The characteristic is filled using a rule of rule type Direct Assignment and one of the following conditions applies:

    • The target characteristic and the source field are of type 'CHAR' but the target characteristic is longer that the source field.

    • The target characteristic has a conversion routine which is usually executed in the transformation.

    • The target characteristic uses one of the basic characteristics 0DATE, 0CALWEEK, 0CALMONTH, 0CALQUARTER or 0CALYEAR as a reference characteristic and the source field is either of type DATS or does not have the same type or length as the target characteristic.

    • The data type of the target characteristic is not the same as the data type of the source field (for example, NUMC characteristic filled from CHAR field) and the target characteristic does not use a basic characteristic 0DATE, 0CALWEEK, 0CALMONTH, 0CALQUARTER or 0CALYEAR as a reference characteristic.

  • The characteristic is a time characteristic, is filled using a rule of rule type Time Conversion and at least one of the following is not true:

    • The time characteristic is an absolute time characteristic 0CALDAY, 0CALWEEK, 0CALMONTH, 0CALQUARTER or 0CALYEAR.

    • The source field is of type DATS or does not have the same type or length as the target characteristic.