We get asked questions about dependency analysis, especially in the BI space, a lot with SQL Server 2005. I think this is for a couple of reasons;
1/ Its a real problem for many customers.
2/ With most of our metadata being available in XML form, it just feels like there should be a way to look at it together.
Well we agree and while we continue to look at solutions for future versions you can get at sample solution here.