Data model with 2 fact tables

Aspiring_Developer — Tue, 27 Jul 2021 06:15:28 GMT

Hi team,

I have below scenario:-

I have created dimensions table and linked it with referenced table like below:-

LET vDimension = 'DIM_PROJECT_DIVISION';$(vDimension):
LOAD
ref_id as %DivisionId,
ref_title as [Division Name]
FROM [...]
(qvd)
WHERE ref_type = 'DIVISION_NEW';

//--------------------------------------------------------------------------

LET vDimension = 'DIM_User_Department';

$(vDimension):
LOAD
ref_id as %OrganizationLevel1Id,
ref_title as [Department Name]

FROM
[...]
(qvd)
where ref_type ='ORG_LEVEL_1_NEW';

//---------------------------------------------------------

LET vDimension = 'DIM_User_Service';

$(vDimension):
LOAD
ref_id as %OrganizationLevel2Id,
ref_title as [Service Name]

FROM
[...](qvd)
where ref_type ='ORG_LEVEL_2_NEW';

//---------------------------------------------------------------------------------------

User:

Load

orga_level_1 as %OrganizationLevel1Id,

division as %DivisionId ,
service_id as %OrganizationLevel2Id
From [....User.qvd](qvd);

Card: Load division as %DivisionId,
orga_level_1 as %OrganizationLevel1Id,
orga_level_2 as %OrganizationLevel2Id

From[....Card.qvd](qvd);

//-----------------------------------------------------------------------------------------

So, i have kind of two fact tables in the above model.

I tried to create link table approach , however it didn't worked because it breaks the link with dimension table like below:-

Can anyone please help me how to resolve this issue ? Please help .

Thank you

topic Data model with 2 fact tables in QlikView

Data model with 2 fact tables