(2211) Step 3. Object adjustment

Owned by SNP
Nov 15, 2022
3 min read

Object adjustment allows you to automatically adjust a CompositeProvider, MultiProvider, Lookups, or DTPs that access a DataProvider previously offloaded by SNP OUTBOARD™ Data Tiering. This step allows the CompositeProvider, MultiProvider, or Lookups to read offloaded data of the DataProvider.

Adjusting a Lookup

  1. To start the adjustment, proceed with the Wizard by clicking Next or choose the main screen from the context menu of specific DataProviders and choose Object Adjustment.
  2. Click on Lookups tab.
  3. Select DataProviders, for which you want to execute the adjustment.
  4. Click Execute adjustment.


Note: Double-clicking on the line will move you to the source code. (Works with reports, classes, and AMDP scripts)


By the execution, SNP OUTBOARD™ Data Tiering generates a code (two includes), which adjusts the lookup, so it can access offloaded data. According to the package of the adjusted lookup, a pop-up appears.

  • An adjusted object containing the lookup is in a $TMP package:
    • A simple pop-up informs that the adjustment is going to be saved into the $TMP package. You can either Confirm or Cancel this action.
  • An adjusted object containing the lookup is NOT in a $TMP package:
    1. Enter a package (1), where you want to save the adjustment. You may use the search help.
    2. Select two transports: The first one for the generated adjustment (two includes), and another one for the adjusted lookup itself (2).
    3. Confirm (3).

                 

When the adjustment process ends, a pop-up with logs appears.

Adjusting a MultiProvider or a CompositeProvider

To adjust a MultiProvider or a CompositeProvider that accesses the added DataProvider into SNP OutBoard™ Data Tiering:

  1. Select the Reporting tab.
  2. Select DataProviders, for which you want to execute the adjustment. You may display all the queries above a CompositeProvider or MultiProvider by clicking .
  3. Click Execute adjustment.

With the execution, SNP OutBoard™ Data Tiering generates a VirtualProvider and connects it to a MultiProvider or a CompositeProvider. This step allows the queries on the selected DataProvider to read offloaded data. According to the package of the adjusted MultiProvider or CompositeProvider, a pop-up appears.

  • An adjusted object is in a $TMP package:
    • A simple pop-up informs you that the adjustment is going to be saved into the $TMP package. You can either Confirm or Cancel this action.
  • An adjusted object is NOT in a $TMP package:
    1. Enter a package (1), where you want to save the adjustment. You may use the search help.
    2. Select a transport for the created and adjusted objects (2).
    3. Confirm (3).

                 

You can switch ON/OFF reading of offloaded data via Queries for each completely adjusted InfoProvider by clicking on the Read Archive button  / 

Custom VirtualProvider names

It is possible to generate the VirtualProviders with custom names. Create a new implementation of the BAdI /DVD/QANA_ADJ_BADI_CUS_VP_NAME in the enhancement spot /DVD/QANA_ADJ_ENHS_CUS_VP_NAME and create a new class, which will implement the interface /DVD/QANA_ADJ_IF_CUS_VP_NAME.


To proceed with the Wizard go to the Step 4. Scheduling.

Not supported

For CompositeProviders that contain both JOIN and UNION assignments, the VirtualProviders (generated by OUTBOARD and inserted into CompositeProvider) are not supported. It is technically not possible by SAP standards.

The activation of CompositeProvider with UNION and also JOIN with multiple ADSOs is successful.

But after inserting VirtualProvider into CompositeProvider the activation ends with an error.

Adjusting DTPs

Adjusting will switch off SAP HANA Execution and parallel extraction and change extraction mode to "Full" in DTP settings. Also, it will check if all data are successfully offloaded and will switch on setting READ_OFF_DATA.