On the internet

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:

4 thoughts on “SQL2005 BI Metadata Samples Toolkit

  1. Hmm, well it was quite old – I guess it has just disappeared from the site. I might have a copy it hanging around on my hard drive, let me take a look…

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.