USER MANUALS


Reference Lineage of Views

The Reference Lineage pill contains a diagram that shows the Reports that use this view and how data flow from the view to the report. Additionally, the node of this view is linked to its Data Lineage diagram, which shows how the current view is built based on other views and how data flows from the data sources into the view.

The Reference Lineage diagram is a reverse tree that has the current view at the bottom, as the root node, and the reports at the top, as leaf nodes. Starting from the current view, it shows four levels: the current view, the Dataset entities, the Datasets and the Reports.

Diagram with the Reference Lineage for a view

Diagram with the Reference Lineage for a view

There are two types of nodes, one line nodes or two line nodes, both show the left-icon, the type and the minus or plus icon, except for the leaf nodes. The two-line nodes also show a left-icon, the name and a more-info icon when the element has a details page. The nodes are divided in three different groups which are identified by a color code in the top-left icon. This classification uses red for Denodo Elements, grey for Data Sources, and blue for External Elements. The group of external elements can also be identified by the icon representing its server type, such as Tableau or Power BI.

To obtain more information about some element click the node and a tooltip will appear with information about the element: Connection Type, Extracts, Dataset Type, Server Type, etc. You can click the more-info icon in the tooltip to get a popup with further information. The view node has an expand button which shows the Data Lineage tree of the current view, when this tree is loaded, the view node is updated with the Denodo’s information, showing more details of this element.

Reference Lineage for a view and the more info tooltip

Reference Lineage for an external element and the more info tooltip

This diagram supports basic operations like zoom in, zoom out, moving the diagram by drag and drop, collapsing nodes in the tree, exporting it as an image, etc.

Note

You will only see the nodes in the tree view that you are allowed to, according to your privileges in Virtual DataPort:

  • For a data source to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will not appear.

  • For a view to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will be replaced with a node labeled with the text No Privileges.

Add feedback