Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Chapter Overview:
Child pages (Children Display)
alltrue
depth2

General

The Data Lineage functionality of the System Scout is a powerful tool to get the mapping of all InfoObjects/Fields of a target entity (e.g. a MultiProvider) from the sources in the Data Flow (e.g. DataSources). 
As a result, you get an Excel file which contains all the information you need to continue your investigations related to mapping or source analysis in System Scout.

Calling up the Function

You can start the functionality for the supported Entities from their context menu. Multiple selection and execution are possible.

Image Removed
Dat Lineage in the System Scout submenu of the context menuImage Added

Structure of the Excel File

Image Removed
Overview page of the generated Excel showing summary and detail sheets for multiple entitiesImage Added

Example: Target entity TAR_ENTITY with FIELD1; in between entity INBT_ENTITY with FIELD2; source entity SRC_ENTITY with FIELD3

The created Excel always contains a sheet "Overview". This sheet shows you a list of all created sheets for the Data Lineage. Two sheets are usually created for each entity (one "Summary" sheet and one "Detail" sheet). In the "Summary" sheet you can find the summarized result of the mappings. The "Detail" sheet shows you the whole mapping over the Data Flow. 
With the example above that means, that you see the following line in the "Summary" sheet:

Target Field

Source Field

Source Object

FIELD1

FIELD3

SRC_ENTITY

In the "Detail" sheet, on the other hand, you see this:

Target Field

  1. Level Object

  1. Level Field

2. Level Object

2. Level Field

FIELD1

INBT_ENTITY

FIELD2

SRC_ENTITY

FIELD3

Supported Entities

Business Warehouse Entities

  • Image Removed

    Image Added Queries

  • Image Removed CompositeProvider
  • Image Removed Advanced

    Image Added CompositeProvider

  • Image Added Advanced DataStore Objects

  • Image Removed

    Image Added Open ODS Views

  • Image Removed 7

    Image Added 7.x InfoSources

  • Image Removed MultiProvider
  • Image Removed InfoCubes
  • Image Removed DataStore Objects
  • Image Removed InfoObjects
  • Image Removed Open

    Image Added MultiProvider

  • Image Added InfoCubes

  • Image Added DataStore Objects

  • Image Added InfoObjects

  • Image Added Open Hub Destinations

HANA Entities

  • Image Removed Attribute

    Image Added Attribute Views

    Image Removed Analytic
  • Image Added Analytic Views

  • Image Removed Calculation

    Image Added Calculation Views

CDS Entities

  • Image Removed

    Image Added Data Definitions