When I try to link the fact twice with the dimension NODE, OBIEE return error 38015 (have multiple joins. Delete new foreign key object if it is a duplicate of existing foreign key).
+--- SW | RELATIONSHIP ===== NODE --- ROLE | +--- PRODUCT
In my case there are several dimensions and NODE is shared with other facts. So I must duplicate everything connected to NODE.
+--- SW_ORG +--- SW_DST | | ROLE_ORG --- NODE_ORG ----- RELATIONSHIP ----- NODE_DST --- ROLE_DST | | +--- PRODUCT_ORG +--- PRODUCT_DST