SQL2005 BI Metadata Samples Toolkit
Courtesy of Karen Watterson, I’ve just found the ‘SQL2005 BI Metadata Samples Toolkit’, downloadable from here:
The demo video that you can see on the page above gives you a good idea of what this set of tools and samples does: it allows you to analyse the dependencies between objects in your AS databases and/or SSIS packages. So for example in an AS database you can click on a cube dimension and it will tell you which database dimension, data source view, data source and relational tables it has a dependency on. Might be quite useful on a large project where you have many developers working on the same cube.
Note that the sample tools need to be edited so that they point to the SQL Server/AS instances you are interested in and then compiled before they will work.
UPDATE: there’s a white paper to go along with these tools which can be downloaded here: