Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Data model with 2 fact tables

Hi team,

I have below scenario:-

Aspiring_Developer_0-1627365416928.png

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:-

Aspiring_Developer_2-1627366450545.png

 

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

Thank you

0 Replies