A consolidated tabular view that depicts the relationships between dimension and fact tables. A bus matrix enables you to identify easily which facts share the same dimension(s). By using this information, you can assess which tables can be combined into one report.
The following 'bus matrix' illustrates how iWD Data Mart aggregate fact tables and dimension tables interrelate.
The following bus matrix demonstrates how iWD Data Mart core fact tables and dimension tables interrelate.