Complicated attribute relationships are difficult to oversee in SSAS 2005. Microsoft solved this problem in SQL Server 2008 with a graphical view of the attribute relationships. Unfortunately, most of us still work with SSAS 2005 and have to wait a couple of months before using the benefits of SSAS 2008.
Until SQL Server 2008 is fully available it’s good to know there is a way to get some of the new features in SSAS 2005: BIDS Helper.
It is free to use and offers a lot more than just the visualization of your attribute relationships:
· Aggregation Manager
· Calculation Helpers
· Deploy MDX Script
· Dimension Health Check
· Printer Friendly Dimension Usage
· Show Extra Properties
· Update Estimated Counts
· Visualize Attribute Lattice
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Jorg Klein, Microsoft Business Intelligence consultant/architect from the Netherlands.