Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
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. |