Consider using a more elaborate schema for the facts and dimensions.  One suggestion above was by functional area.  I identify via schema the source database for the tables.  As I use views for all the dim and fact tables (a suggestion from Kimball's 3rd edition book) the schema for those identifies the supported cube.  Works great, although sometimes the DSV is a little fiddly when working with views versus tables.