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 |
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. |
Copyright Kyvos, Inc. All rights reserved.