BI Documenter - VCU Health System
"The time and effort BI Documenter saves my team by documenting the entire BI stack is priceless."
Carlos Dickens

Manager, Data Warehouse

VCU Health System

BI Documenter - John Dempsey
"BI Documenter allowed me to document not only the database objects, but SSIS, SSRS, and SSAS too. This is a great benefit. It provided access to their metadata database repository the software used which I felt was a big plus. A must have tool."
John Dempsey
BI Documenter - Microsoft
"I'd say you have a very impressive and extremely useful product here. I highly recommend [BI Documenter] to anyone who wants to take snapshots of their SQL Server BI solution... Cool product."
Kirk Haselden

Development Manager

SQL Server Integration Services, Microsoft Corporation



Buy NowFree Trial Download Free Live Demo!

Object Lineage and Impact Analysis 

The Impact Analysis and Object Lineage in BI Documenter will show users how objects are related in their environment. It will generate easy to read diagrams that can be saved to each snapshot.

Feature Highlights:

  • Display Parent and Child Dependencies between SQL Database Objects, SSIS Packages, SSAS Cubes and Databases, and SSRS Reports.
  • Render Parent and Child Dependencies in both Diagram or List form
Object Lineage and Impact Analysis

Impact Analysis/Object Lineage - Step 1
From the ‘Review Your Solution’ screen, click the ImpactAnalysis/Object Lineage’ link.

From the ‘Review Your Solution’ screen, click the ImpactAnalysis/Object Lineage’ link.

Impact Analysis/Object Lineage - Step 2
There are four tabs in this window; one for each type ofobject in the documentation.

There are four tabs in this window; one for each type ofobject in the documentation.

Impact Analysis/Object Lineage - Step 3

To see the impact analysis of a SQL table, expand thedatabase node and then expand the table node. Right click on the name of thetable. There are two options; render as diagram, or render as list.

Select ‘Render as Diagram’.

To see the impact analysis of a SQL table, expand thedatabase node and then expand the table node. Right click on the name of thetable. There are two options; render as diagram, or render as list.

Select ‘Render as Diagram’.

Impact Analysis/Object Lineage - Step 4
This generates a diagram of everything in the environmentthat has a relationship to that table in some way. This includes tables, views,triggers, stored procedures, and more.

This generates a diagram of everything in the environmentthat has a relationship to that table in some way. This includes tables, views,triggers, stored procedures, and more.

Impact Analysis/Object Lineage - Step 5

To change the focus of the impact analysis, double click oneof the other objects. For example, double click the report.

This changes the focus of the Impact analysis, and now showsall the tables from which the report pulls data. It will also show any storedprocedures the report uses to extract data.

These diagrams can be saved to the snapshot or as an imagefile on the hard drive.

To change the focus of the impact analysis, double click oneof the other objects. For example, double click the report.

This changes the focus of the Impact analysis, and now showsall the tables from which the report pulls data. It will also show any storedprocedures the report uses to extract data.

These diagrams can be saved to the snapshot or as an imagefile on the hard drive.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works