I have following problem:
Agent is directly related to both Customer and Vendor.
Customer CAN be related to Vendor by contact, but doesn't have to be.
The problem is, that for Customer's dimension Agent attribute, it tries to lookup not directly through Agent table, but instead through Contact -> Vendor -> Agent. And fails, since those rarely exist.
Why does it do that? Why doesn't it use direct relationship?
View Complete Post