4 Replies Latest reply: Dec 8, 2015 8:13 AM by Evgeny Stuchalkin RSS

    Problem with data model

    Evgeny Stuchalkin

      Hello! I'm have some problem with data model. Here's my story.

       

      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.

      But when i'm loading this fields, my statistics become broken.

       

      See details in that video.