Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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):LOADref_id as %DivisionId,ref_title as [Division Name]FROM [...](qvd)WHERE ref_type = 'DIVISION_NEW';
//--------------------------------------------------------------------------
LET vDimension = 'DIM_User_Department';
$(vDimension):LOADref_id as %OrganizationLevel1Id,ref_title as [Department Name]
FROM[...](qvd)where ref_type ='ORG_LEVEL_1_NEW';
//---------------------------------------------------------
LET vDimension = 'DIM_User_Service';
$(vDimension):LOADref_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 %OrganizationLevel2IdFrom [....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