Exporting a bus matrix to Microsoft Excel is easy: go to “Tools > Export > Bus matrix to Excel”. 


In seconds an Excel file will be generated for you containing two bus matrices for the current project.

The first one reports conformed hierarchy usages across fact schemata:

The second one displays the same information, but aggregated by Aggregation level, so you can analyze how conformed hierarchies are used in your project: