Visual View

Parent Previous Next

Visual View


Lineage Analysis' Diagram Mode allows users the ability to visually navigate the dependencies found within a specific solution. Diagram Mode is divided up into three panels: Diagram Toolbar, Solution Explorer, and Lineage Diagram.


Diagram Toolbar

The diagram toolbar allows users to navigate around and adjust the behavior of Lineage Analysis.


  Back to Solution Selection: Allows users to go back to the list of available solutions for use within Lineage Analysis


  Text View: Allows users the ability to view the currently selected solution within Lineage Analysis' Text View


  Detail Level: Allows users the ability to adjust the granularity of the objects that will be included within the current session of Lineage Analysis

o   High Detail: Allows users the ability to see down to the column, measure, and attribute level of lineage

o   Medium Detail: Allows users the ability to see down to the table, component, SSRS item, KPI, and measure group level of lineage

o   Low Detail: Allows users the ability to only see the database, package, and report level of lineage

  Relationship Filter: Allows users the ability to adjust the types of dependencies to include within the current session of Lineage Analysis

o   All: All relationship dependencies will be included within the current session of Lineage Analysis

o   Data Lineage: Only relationship links that involves the impact or dependency of another object's data will be visible

o   Key + Object: Only relationship links that involve the use of primary or foreign keys or object dependencies will be visible


  Dependency Directions: Allows users the ability to adjust the direction types of the dependencies to include within the current session of Lineage Analysis

o   Bi-Directional: Both inbound (lineage) and outbound (impact) dependencies will be included within the current session

o   Inbound Only: Only relationships that an object depends on will be included within the current session

o   Outbound Only: Only relationships that are impacted by objects will be included within the current session


  Diagram Layout: Allows users to control the way objects are organized within the lineage diagram

o   Tree: Organizes the diagram in a hierarchical way surrounding the focused object

o   Force-Directed: Organizes the diagram in a nondeterministic manner surrounding the focused object

o   Layered: Organizes the diagram with an emphasis on the flow of the diagram while minimizing the crossing between each layer and node surrounding the focused object


 Track Selection: Allows users the ability to disable the feature that causes the diagram to re-draw every time a new selection is made within the Solution Explorer

 Dependency Level: Allows users to increase or decrease the number of levels of separation from the currently focused object to be displayed within the Lineage Diagram.


Important Note:

The more dependency levels included within the Lineage Diagram may cause it to become increasingly more difficult to read the diagram.


Solution Explorer

The solution explorer contains a hierarchically organized tree of all objects found within current detail level that contain lineage. If track selection is enabled, left clicking on an object within the solution explorer will re-draw the lineage diagram focused on the currently selected object.



Users can expand and collapse object, displaying the object's children, using the arrow to the left. If an object does not have an arrow, or the arrow disappears after clicking, then that object either does not have any child objects that contain lineage or the current detail level prevents it from expanding further.


Lineage Diagram

The lineage diagram takes up a majority of the window within Lineage Analysis' visual view. It applies all of the settings selected within the diagram toolbar to the currently focused object within the solution explorer to create a visual representation of the object's lineage.


The use of icons and color within the diagram will help users quickly identify the object and technology types associated with each node. Below is an abbreviated list of the colors and icons used for the main technology types, though other icons are used throughout the lineage diagram as well.


SQL Server Objects

SSIS Objects

SSAS Objects

SSRS Objects

Other Objects


Including the three buttons in the upper right of the lineage diagram, the lineage diagram does have other ways of navigating the diagram in a meaningful way.


  Move Node: Left-clicking on a node and then dragging the mouse allows users the ability to move a single node around the diagram without affecting the other nodes.


  Pan Diagram: Holding down the Control key and left-clicking the lineage diagram allows users to pan the lineage diagram to see more of the diagram if it does not all fit within the screen.


  Reset Zoom: Clicking the reset zoom button allows users to reset the zoom of the lineage diagram to its default value


  Zoom In: Clicking the zoom in button allows users to decrease the size of the objects within the lineage diagram


  Zoom Out: Clicking the zoom out button allows users to increase the size of the objects within the lineage diagram



The arrows connecting nodes together also provide users with a way to quickly identify the direction of the relationship between the two objects. If only one side contains an arrow, then the node with the arrow depends on other node. If both sides contain an arrow, then both nodes depend on each other.


If documentation has already been generated, some objects within the lineage diagram may be associated with a documentation page. Right-clicking on a node will launch a context menu containing a list of the latest documentation outputs that contain the selected object. Clicking on a documentation output will launch a separate window that will navigate the user to the object within the selected documentation output.