BI Documentor – Lineage Documentation for SQL Server

How do you use it as BI Documentor?

SQL Documentor can be used to generate Lineage Documentation for your databawarehouse and Business intelligence reporting.

You can add your own SQL queries within SQL Documentor and then link it to detail or child level queries. This in turn can be drilled into another level of queries. Once your drills are defined, you are effectively creating a lineage from the Datawarehouse meta-data to the transaction source level.

Once all is setup, you can create a PDF or HTML document and it will generate a complete BI Document for handy reference.

You can learn here on how to create drills

Tags: , , , ,

Post a Comment