Joins in a view: How can I have it detect the foreign keys instead of matching by field name?
We have many tables to join that all have complex keys. Is there a way to have Yellowfin detect the foreign keys? Matching by fieldname doesn't work very well in our case. It picks up too many fields. I know they can be removed, but it becomes cumbersome for the number of joins we require, and the number of views we need to create.