Object Level
Data Lineage at Object level for BW Entities.
We export two files: one file with all the relations of BW Entities (“Relations”) and one file with more details (e.g. Technical Name and descriptions) (“Details”) of the entities.
The supported entities are the following:
-
BW Queries
-
Restricted Key Figures
-
Calculated Key Figures
-
Composite Providers
-
Advanced Data Store Objects (ADSO)
-
Open ODS Views
-
InfoSources
-
DataSources
-
InfoObjects as InfoProviders
-
Open Hub Destinations
-
Aggregation Levels
-
AfO Workbooks stored in BW
-
MultiProvider
-
Data Store Objects
-
InfoCubes
-
InfoSets
-
HybridProvider
-
HANA Artifacts consumed by Composite Providers and Open ODS Views
Details
These parameters are displayed per object:
-
Object ID
-
Technical name
-
UID (for Reporting elements & Transformations)
-
Object Type
-
InfoArea
-
Descriptions for the languages set in the configuration file
-
Logical system (for DataSources)
Relations
In the “Relations” file, only entities that have a connection in a data flow are included. E.g. an Advanced DSO without an incoming or outgoing transformation or a Composite or Open ODS View on top is not listed in the data.
This information is displayed:
-
Nodes: ID of Objects with a relation to another
-
Edges: Relation ID, ID of Source and Target Object.
Field Level
Data Lineage at Field/InfoObject level for BW Entities.
Three files are exported: one file with the buildup of BW entities (“Buildups”), one with the descriptions of the fields and InfoObjects (“Buildup Descriptions”), and one file with the mappings between the fields and InfoObjects (“Mappings”).
Buildups
The fields and InfoObjects, and their parameters are displayed per objects like this:
InfoProviders
-
Parent ID
-
Field ID
-
Technical name
-
Data type
-
Length
-
Constant: value of the constant
-
Formula
-
Associated object
-
Semantics (for Open ODS Views)
-
Navigation attributes
-
ID
-
Technical name
-
-
-
Queries
-
Parent ID
-
Filters on Query level on
-
Characteristic values
-
Variables
-
Hierarchies
-
-
Elements
-
UID or tech name
-
Query specific descriptions
-
Element-specific parameters (e.g. length, value or operator)
-
-
Transformations
-
Parent ID
-
Nodes
-
Node ID
-
Rule Type & value/formula
-
-
Definition of Key Figures
The definitions of key figures on the Reporting level are also read. The definitions of Calculated Key Figures, Restricted Key Figures, Local Formulas, and Local Selections are collected.
Buildup Descriptions
The Buildup Descriptions file lists the IDs and descriptions of all fields.
Mappings
In the “Mappings” file, only fields and InfoObjects connected in the data lineage are included.
These mappings are supported:
-
Mappings in Composite Providers
-
Direct Assignment
-
Formulas
-
Constants
-
-
Mappings in Open ODS Views
-
Assignments/rules in Transformations
-
Description of rules in Transformations
-
Type of rules in transformations (Constant, Formula, Field Routine, Lookup, End Routine, Start Routine, Expert Routine Direct Mapping)
-
Value of constants rules
-
Definition of formulas rules
-
Lookup object of lookup rules
-
All field and InfoObject Mappings are supported only for the BW entities.
This information is displayed:
-
Nodes: ID of fields or InfoObjects with a relation to another
-
Edges: Relation ID, and ID of Source and Target Field or InfoObject.