Impact and Lineage Analysis
The Impact and Lineage Analysis diagram helps you to understand the lineage or data provenance of a selected object or one or more of its columns, along with its impacts - the objects that depend on it and that will be impacted by any changes that are made to it.
Open the Diagram
-
In the Repository Explorer or the Data Builder start page, select an object to analyze and click in the toolbar.
-
In the Catalog, click the Open Impact and Lineage Analysis button on the asset details page.
-
In Data Builder object editors, click in the toolbar or, if the editor contains a diagram, select a table, view, or data flow symbol and click the tool in the symbol toolbar.
Control the Diagram Layout
|
Tool |
Description |
|---|---|
|
Data Analysis / Dependency Analysis |
Toggle between the two modes:
|
|
Search |
Find and select objects in the diagram. Results are proposed once three characters are entered. Click a result in the list to select the object symbol and highlight other objects on its path to the analyzed object. |
|
Lineage |
Enable/disable the display of the lineage of the analyzed object. |
|
Impact |
Enable/disable the display of the impacts of the analyzed object. |
|
Layout |
Change the orientation of the diagram:
|
|
Reset |
Restore the default layout. Changing the mode also resets the layout. |
|
|
Scroll, zoom, or recenter the diagram:
|
|
Symbol |
Description |
|---|---|
|
|
The object being analyzed. You can show or hide the objects on either side of this or any object by clicking the or buttons on the symbol. |
|
|
Objects appearing in the lineage or impacts of the analyzed object. If you do not have permission to view an object, it is shown with the icon and the name Unauthorized. |
|
|
Spaces that contain objects appearing in the lineage or impacts of the analyzed objects. The number in brackets indicates the total number of objects in the space that are part of the impact or lineage of the analyzed object. You can expand or collapse a space, using the menu on the top-right corner of the symbol. If you do not have permission to view a space, it is shown with the icon. |
Display Object Properties and Analyze or Open Objects
|
Icon |
Description |
|---|---|
|
|
Persisted and replicated objects have their data copied locally to enhance performance (see Persist Data in a Graphical or SQL View and Replicate Remote Table Data). |
|
|
Exposed objects can be consumed by SAP Analytics Cloud and other BI clients, tools and apps (see Exposing Data For Consumption). |
|
|
Contains personal or sensitive personal data (see Modeling with Personal Data). |
|
|
Deployment Status (see Saving and Deploying Objects). |
|
|
Release State (see Releasing Stable Views for Consumption). |
|
|
Number of columns in the object. Click to see the column list and, in the case of the analyzed object, to select one or more columns for analysis (see Column Analysis). |
|
Tool |
Description |
|---|---|
|
|
Preview the object's properties. |
|
|
Change the focus of the diagram to analyze this object. You can go back to the previous diagram by clicking in the dialog header. |
|
|
Open the Runtime Metrics tool to analyze the performance of your view. This tool also provides the option to directly generate and download an Explain Plan or execute View Analyzer to improve your view performance. |
|
|
Open the object in its editor in a new browser tab. |
Dependency Analysis Mode
While the default Data Analysis mode focuses exclusively on data movements and transformations, the Dependency Analysis mode adds objects that are connected to the analyzed object by associations and data access controls.
In this example, the Sales View entity shows a single source table in Data Analysis mode:
In Dependency Analysis mode, it shows several other entities, to which it is linked via associations, along with a data access control:

-
- Association pointing to another entity to indicate a potential join between them (see Create an Association to Define a Semantic Relationship Between Entities).
-
- Data access control providing row-level security (see Securing Data with Data Access Controls).
Column Analysis
-
Click the columns button on the analyzed object to open the list of columns.
-
Select one or more columns that you want to analyze and then click Select.
The diagram refreshes to show the selected columns under the analyzed object and columns implicated in their lineage or impacts under all other relevant objects. A green filter bar shows the number of columns selected.
-
[optional] Click any column in the analyzed object (or any other object) to highlight its participation in the graph.

-
You can change your column selection at any time, and leave column analysis by clicking the X on the right of the filter bar.



