Document toolboxDocument toolbox

Data Lineage

Chapter Overview:


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 that 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.

Structure of the Excel File

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 FieldSource FieldSource Object
FIELD1FIELD3SRC_ENTITY

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

Target Field
  1. Level Object
  1. Level Field
2. Level Object2. Level Field
FIELD1INBT_ENTITYFIELD2SRC_ENTITYFIELD3

Supported Entities


Business Warehouse Entities

  •  Queries
  •  CompositeProvider
  •  Advanced DataStore Objects
  •  Open ODS Views
  •  7.x InfoSources
  •  MultiProvider
  •  InfoCubes
  •  DataStore Objects
  •  InfoObjects
  •  Open Hub Destinations

HANA Entities

  •  Attribute Views
  •  Analytic Views
  •  Calculation Views

CDS Entities

  •  Data Definitions

© 2023 bluetelligence GmbH. All rights reserved.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy