Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Applies to:Kyvos Enterprise  Kyvos Cloud (Managed Services on AWS)  Kyvos Azure Marketplace

Kyvos AWS Marketplace  Kyvos Single Node Installation (Kyvos SNI)  Kyvos Free (Limited offering for AWS)


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.

  1. From the Toolbox, click Semantic Models.
  2. Select a semantic model from the list. 
  3. Select the Define Semantics tab if needed.
  4. Click the Actions menu (...) menu next to the properties pane. 
  5. Choose Export Data Field Lineage.
  6. Specify the line separator, field separator, and enclosed by characters or use the defaults. 
  7. Click the checkbox to include the header.
  8. 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 PropertiesThis 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.

  • No labels