I'm pretty new to OLAP. What I've decided to try is creating a relational db which just has views for each table. Each view unions selects from the multiple client databases, plus adds a DatabaseId column. I'll use a composite key (ex DatabaseId, CustomerId) in the relationships to the dim tables.

Another option would be to build the same db with tables instead of views.