Exporting data lineage

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

You can download the data field lineage information of the semantic model design in a CSV format. This is the information you see in the Logical view. If the semantic model has SQL as a source, a zip file is created with a separate SQL file for each SQL source along with the data lineage CSV file.

To export data lineage, perform the following steps.

From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Select the Define Semantics tab if needed.
Click the Actions menu (...) menu next to the properties pane.
Choose Export Data Field Lineage.
Specify the line separator, field separator, and enclosed by characters or use the defaults.
Click the checkbox to include the header.
Click Apply.

Columns will be exported as:

Column Name	Description
Semantic Model Field Type	Attribute, Level, Measure, Calculated Measure, Named Set, Display Field, Sort Field, or ParentKey Field (in case of parent-child relationship).
Semantic Model Field Name	Name of the Attribute, Level, Measure, Calculated Measure, or Named Set.
Parent Name/Group Name	Name of the Dimension or Measure Group.
Dataset Name/RF Name	Name with folder names, such as Folder Name > RF Name or Dataset Name
Source Type	File, Table, or SQL, Formula Field, or MDX Expression
Source Name	This column displays the name of the source, such as File Name, Table Name, SQL, Formula Expression, MDX Expression Table Name Pattern is displayed as Database Name > Schema Name > Table Name.
Source Field Name	This column displays the name of the source field or Formula Name. Blank in the case of Calculated Measure.
Description	Description of the Attribute, Level, Measure, Calculated Measure, Named Set, or Description Field.
Member Properties	This column contains details of any member properties applied to the attributes or levels.

In case there were any member properties, the exported data lineage will also show:

Column Name	Description
Semantic Model Field Type	LEVEL MEMBER PROPERTY / ATTRIBUTE MEMBER PROPERTY
Semantic Model Field Name	Name of the Attribute, Level
Parent Name/Group Name	Name of the Dimension
Dataset Name/RF Name	Name with folder names like Folder Name > RF Name or Dataset Name
Source Type	File, Table, or SQL, Formula Field, or MDX Expression
Source Name	This column displays the name of the source, such as File Name, Table Name, SQL, Formula Expression, MDX Expression. Table name pattern is displayed as Database Name > Schema Name > Table Name
Source Field Name	This column would have the name of the source field
Description	Description of the Attribute, Level.