Let users dynamically change database schema

have yo utry dataflows? you could create a dataflow to model each one separated, and make tranformations to do a table matching format and them combine them in a new single dataflow that just append the table having a column that separates the UK vs US fact info and a global dim tables, them using users rules you can specify what data each user group have permits with the use of roles