BW Inversion Routine in SAP BW BI

Use

If you have defined transfer routines in the transfer rules for the InfoSource of a SAP RemoteCube, for performance reasons, it makes sense to also create inversion routines for each.

When jumping to a transaction in another SAP system using the report-report interface, you have to create an inversion routine for the transfer routine if you are using one, because otherwise the selections cannot be transferred to the source system.

Functions

You create an inversion routine in the routine editor for the already defined transfer routine. This routine is required, for example, during execution of queries on SAP RemoteCubes in order to transform the selection criteria for a navigation step into selection criteria for the extractor. The same goes for jumps to another SAP system with the report-report interface.

The form routine has the following parameters:

· I_RT_CHAVL_CS: The parameter contains the selection criteria for the characteristic in the form of a selection table.

· I_THX_SELECTION_CS: The parameter contains the selection criteria for all characteristics in the form of a hash table for selection tables of the individual characteristics. You only need this parameter if the inversion is still dependent on selection criteria of other characteristics.

· C_T_SELECTION: In this table parameter you have to return the transformed selection criteria. The table has the same structure as a selection table, but it also contains the field names in the FIELDNM component. If an empty table is returned for this parameter it means the table is a selection of all values for the fields used in the transfer routine. If an exact inversion is not possible, you can also return a superset of the exact selection criteria. In case of doubt, this is the selection of all values that was also provided as a suggestion during creation of a new transfer routine.

· E_EXACT: This key figures determines whether the transformation of selection criteria was executed exactly (constant RS_C_TRUE) or not (constant RS_C_FALSE).

Activities

Enter your program code for the inversion of the transfer routine between *$*$ begin of inverse routine ... und *$*$ end of inverse routine ... so that the variables C_T_SELECTION and E_EXACT are provided with the appropriate values.

With an inversion routine for a SAP RemoteCube it is sufficient if the value set is restricted in part. You do not need to make an exact selection.

With an inversion routine for a jump via RRI, you have to make an exact inversion so that the selections can be transferred precisely.

Example

You can find an example of the inversion routine by clicking Routine Info in the routine editor.