I'm trying to find a way to automate the Description property of a
column in our Data Source View in SSAS 2005. We use ERStudio to
document our relational database. We would like to use it to create an
extended property on the columns in our SQL Server 2005 database that
we can then automate populating the Description property of our data
source view in SSAS 2005. Of course, we then want that description to
propogate to the Description property of the measure or dimension
attribute. And then, finally, use a tool (e.g. BIDocumenter) to
produce end user documentation.

Has anyone done this or have any ideas on how to accomplish it?

Thanks in advance.