First: I have two separate data bases as data sources (for two countries). Both DB contains same tables and fileds.

Second: I have 4 general tables in data model: leads, companies, tasks, notes. I'm joining tables from different DB in load script.

Leads joined to companies by field Company ID. All 4 tables connected to master calendar.

Third: for purpose of filtering Counties in my application, I have additional table amo_users, that contains names of responsibles. Each responsible have assotiated contry with him (marked with red), like:

LIB CONNECT TO 'rcs-kz';

LOAD name as Ответственный,

'Казахстан' as [Филиал];

SQL SELECT name

FROM `lsvidaniru_rcskz`.`amo_users` where `name`<>'Евгений Стучалкин';

join LIB CONNECT TO 'rcs-msc';

LOAD name as Ответственный,

'Москва' as [Филиал];

SQL SELECT name

FROM `lsvidaniru_rcsrf`.`amo_users` where `name`<>'Евгений Стучалкин';

When i'm using 'Responsible' field only in Leads table, everything is ok.

Fourth: tables Tasks and Notes have Responsible field too. And i'm need use them to display individual statistic of managers.