Help to solve a problem with sintetic keys

[FelipeBravo]

I have the table fact Venta with the foreing keys Local_Id,Producto_Financiero_id, Cuenta_Id, Tarjeta_Id, Cliente_Id,Subcanal_Id. And I want to join those foreing keys directly to the Primary keys of his tables, but the qlick Sense aplication create sintetic tables for join those keys throw them. There is a solution for make the direct join, the FK  even have the same name for those join automatically. Thanks in advance

[martinpohl]

if the combination of many fields is the only right combination of links you have to create a combined field in both tables

eg

Producto &'-'&localId&'-'&subcanalId as Key

In one table let the single fields as select able values (eg only select one subcanal)

Regards