I have just finished a sample Warehouse Adapter that demonstrates how to customize the Warehouse and Analysis databases.  This is a fairly simple sample, but should help out anyone considering customizing the Warehouse.

Take a look:

http://code.msdn.microsoft.com/Tfs2010SampleAdapter