1. Yes you need to load the Sales number to join based on this field.
Because QV considers Company Performance as one table and the table derived from the company performance as another. By this it joins the data based on the common fields(field name in common).
2.Can you explain you question as briefly?
Thanks for the reply,
Regarding the first question: SalesNumber was loaded every time we used it, is that right?
I mean I can find it in at least 6 Left Join in the script.
in the script we load Origin and at the end we group by Origin, do I need to Load Origin every time I will Group By Origin ?
You must load the Dimension field which is going to be used in Join. For example in the below script
max(SalesNumber) as MaxAXESalesNumber
Resident CompanyPerformance GROUP BY Origin;
You have load Origin then only the Origin in the load table is joined with CompanyPerformance.Origin value.
Hope this helps you.