Hi All, if I have a dimension table "DimService" and it has 2 foreign keys to another dimension table "DimCustomer" on 2 different FK fields, lets say they are called SellTo and BillTo Customer.
If I wanted to show properties from both SellTo Customer and BillTo Customer it doesn't seem possible as there is no way to tell the dimension builder *which* relationship to go down for the magical join that it must be producing.
Is there any way to do this?
I have worked around it by creating named queries in the DSV (DimCustomerSellTo and DimCustomerBillTo) but of course this means that it needs to load the same data twice on processing which is sub-optimal.
View Complete Post