Working with Modeling Content in a Project

Data lineage shows all the calculation views and source tables on which a given calculation view depends.

The purpose of impact analysis is to show all the chain of calculation views that depend on a given calculation view.

Hint

In the Data Lineage or Impact Analysis view, you can directly open a calculation view from the dependency tree by double-clicking it.

From QRC 3/2022, SAP HANA Cloud is able to perform a lineage and an impact analysis not only within a given HDI container, but also towards another HDI container.

This feature is useful, when calculation views from a container are consumed by calculation views from another one, to check as exhaustively as possible how a change you make to a calculation view might impact another HDI container. You can also, similarly, track all the dependencies of a calculation view, including the ones located in an external container.

Note

The privileges of the _RT user (the technical user interacting on your behalf with the HDI container) determine which objects are visible outside of the HDI container.

So, if the _RT user has system privilege CATALOG READ, all objects are visible. Otherwise, only the objects for which the _RT user has an object privilege, such as SELECT, are visible.

Column lineage is useful when columns are renamed within the calculation scenario, or when you want to see quickly where a calculated or restricted column originates from.

It also helps you to avoid mixing up columns with the same name, but not necessarily the same data that are present in several nodes of a calculation view.

For example, the NODE_KEY column in an SAP ERP system is used in many tables to join the master data-defining attributes.

You might want to make sure that the NODE_KEY column in the output of a dimension calculation view originates from the correct table (for example, the table SNWD_BP containing business partners) and not from another table, also used in the calculation view, in which a NODE_KEY column is present but does not identify business partners (for example, the NODE_KEY in the table SNWD_AD containing Contact addresses).

Note

The Show Lineage feature stays active until you exit the Show Column Lineage mode by choosing Exit.

Watch this video to learn about the Outline View.

Note

Make sure you don't mix up the Outline feature of the calculation view editor with the general Outline view of SAP Business Application Studio, which displays structured code into a hierarchy.