Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) 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.

  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.

...

  1. Image Added
  2. Specify the line separator, field separator, and enclosed by characters or use the defaults. 

  3. Click the checkbox to include the header.

  4. Click Apply.
    Image Modified

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.