Versions Compared

Version Old Version 1 New Version Current
Changes made by

SNP

Marian Vidra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Impact analysis supports two types of lookups:

  • Lookup - standard SQL statement in a report, class, routine, etc. that selects data from the active table of an InfoProvider
  • Dynamic lookup - a standard lookup, with the difference that the source table name is a variable (e.g. SELECT * FROM (lv_tabname) WHERE

...

  • , etc.).


In this section:

Child pages (Children Display)

When the step Object adjustment is executed, DataTiering automatically adjusts the original report with the class /DVD/OFF_CL_DATAPROV_QUERY to read already archived data.

This ensures that the output data is enhanced with archived data. A step by step guide on how to translate the standard lookups is in the section (2111) DataProvider Wizard.

Image Modified 

Image Modified

How to translate dynamic lookups

Dynamic lookups are standard SQL select statements, but they contain a dynamic variable. For example SELECT * FROM (lv_table) where lv_table is a variable with a value that may change. Therefore, the select statement isn't associated with a particular DataProvider.

Dynamic Lookup Wizard can be accessed by a separate transaction /DVD/OFF_DLW.

Image Modified

The execution of the Impact analysis and Object adjustment is very similar to the standard lookup translation in the (2111) DataProvider Wizard. The difference is that after you click Execute analysis a filter screen appears, in which you set the objects that should be analyzed.


Image Modified

Search Pattern: If this select option is set, only objects with a source code that contains one of the entered substrings are analyzed.

Object ID: If this select option is set, only objects suiting these selection criteria are analyzed.