This is Part Two, the final of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.
In the first part of this blog post series, which can be found at this link, I discussed the benefits of a Business (Bus) Matrix that can be automatically generated from a SQL Server Analysis Services Tabular Model. Typically, Project Managers and Lead Architects cannot always confirm that a Tabular Model is built to Requirements & Design planning specifications until development is complete and testing begins. An automated Bus Matrix would allow for the Tabular Model to be compared to a Project Management specifications checklist, which usually includes a Bus Matrix that was manually created before development began. With this methodology, discrepancies can be mitigated much earlier in the development process, minimizing rework. Existing Tabular Models that have sparse documentation, or which undergo frequent iterative changes, could also benefit from an automated Bus Matrix.
As promised in the first half of this blog post series, we are going to get to the nuts and bolts of building an automated Bus Matrix using DMV queries from a Tabular Model.