Script - SSAS Bus Matrix Generator
This Excel Macro tool will generate the Bus matrix based on the relationship between the Dimension and Measure Groups.
1. Can provide multiple server and Cube in one shot to create a combined Bus Matrix
2. Works for both Multidimensional Models and Tabular Models.
3. Bus Matrix generated is a pivot table and can be used to for further analysis with slicing and dicing.
This tool is based on the DMVs in the cube. Make sure your id has relevant permissions. As this is Macro enabled excel , Please make sure to enable the execution of the macro while opening the excel file.