Divya Agrawal

Divya Agrawal

Divya Agrawal

Divya has proficient experience in SQL Server database and Business Intelligence technologies from Design to Development. She is passionate about accelerating development and have been contributing many user friendly and configurable utilities. She has designed effective solutions and resolved business-critical issues using skilled SQL queries and techniques.

View all posts by Divya Agrawal
Divya Agrawal

Latest posts by Divya Agrawal (see all)

Automate documentation of SQL Server Analysis Server Tabular Model

March 13, 2018 by

There has been an ever-growing discomfort on documenting things especially when it’s very dynamic in nature and I was at one time undergoing the same. We have been developing SQL Server Analysis Tabular Model’s, which were quite a many in numbers and documenting 50 or 60 models manually is a big effort. In addition, development always demands change or enhancements that incurs changes on the documentation that is a continuous process. Adding the changes on the documentation is a time consuming process and sometimes loses track or remains inconsistent with the code built which is a critical issue when the system is in production for years.

I decided to automate the documentation of the SSAS model, to ease the manual effort here as well as save time. In addition, help the end users to see and review the latest change on the models quickly without even bothering the development team.

Read more »