Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

SQL2005 BI Metadata Samples Toolkit

with 4 comments

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:

Written by Chris Webb

December 19, 2005 at 1:35 pm

Posted in On the internet

4 Responses

Subscribe to comments with RSS.

  1. it would seem that link no longer works

    Michael

    March 6, 2008 at 3:56 pm

  2. 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…

    Chris

    March 7, 2008 at 9:02 am

  3. Cool bean
    I hoping to leavage off of the work
    thanks
     

    Michael

    March 7, 2008 at 6:51 pm


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,131 other followers

%d bloggers like this: