SSAS – Visualize Attribute Relationships

Posted by

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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s