I had a look at Pragmatic works BI documenter. It's pretty good.
I think Microsoft's next big step in the BI world should be a centrally managed meta data repository solution that allows the graphical representation of source to target for any BI solution. I believe that Informatica and one or two other solutions already offer this.