I have 2 tables: Fct_ServiceJob and Fct_ServiceJobItem. They are linked together by Service Job ID and CompanyID.
In dimension usage, I would specify that their relationship is regular. The thing is, i can only specify the ServiceJobID field as their link and i dunno how i can add the Company ID. Can i
Should I do the linking of these tables on the SQL views instead and call this view in analysis instead of setting it in AS
cherriesh