The Cube and Dimension Analysis area allows the relationships between cubes and dimensions to be explored. It can be accessed by selected the "Cube and Dimension Analysis" option in the sidebar.
The reports come in useful:
- When designing - you can understand what dimensions you have available and where they are used. Based on that you can decide whether or not to include them in a new model.
- For identifying redundancies - you can see when dimensions do not belong to any cubes and drill on them to explore how they are used.
- When building test plans - As you plan to make changes to dimensions you can see which cubes they impact instantly.
In the reports you can add in the dimensions that you want to analyze / assess the overlap or click on the counts to see all of the related objects.
Alternatively you can swap the rows and columns to view Dimensions by cubes.