Best way to document Dwh views
There are basically two ways to do this in a maintainable way:


Use a metadata framework to generate the data warehouse
Use Extended properties
(http://technet.microsoft.com/en-us/library/ms190243(v=sql.105).aspx)


Ad 1) The reason you are having this issue on the first place is that you are not creating metadata first and then using that metadata (with a simple code generator) to generate the tables and views in the database. There are several frameworks available that will allow you to have an almost pure meta driven data warehouse model. Check out TimeExtender (http://www.timextender.com/) and Vulcan (https://vulcan.codeplex.com/) for a few examples. With metadata driven modelling, documentation happens as a natural part of the modeling process

Ad 2) If you already have a model (which it sounds like you do) a great way to document it to end users, is to add Extended properties to the views as you develop/maintain them. These properties be added both to the view itself and to do the columns in the view. With a simple piece of code in your favourite programming languages - you can query the extended properties to auto generate documentation. A good way to expose this documentation to the end user is to render web pages, so they can navigate the data model from there. Another advantage of this model is that the documentation now lives inside the database (you can back it up as part of your routine backup procedure) and the BI developers have it available at their fingertips (nobody likes to document code in Word documents)