Group by clause only works when using all dimensions
The following load statement doesn't work, when not using all of the loaded dimensions. (here in this example I didn't use TYPE_OF_SVC.
Load KEY_Ausland, PERIODE_NR_ROW, CARRIER_ALN_CD_ROW, TYPE_OF_SVC, SUM(CAP_FST_AMT+ CAP_BSN_AMT+ CAP_PEC_AMT+CAP_ECO_AMT ) as SEATS_TTL_NR_ROW, sum(STARTS_TTL_NR_ROW) as STARTS_TTL_NR_ROW Resident Nachfrage_Angebot_Temp Group by KEY_Ausland,PERIODE_NR_ROW, CARRIER_ALN_CD_ROW; //,TYPE_OF_SVC; Drop Table Nachfrage_Angebot_Temp;
Re: Group by clause only works when using all dimensions
If you use a GROUP BY then all the fields that are not used in aggregation functions (like sum) must be included in the GROUP BY clause. So a field is either in the GROUP BY or used in a sum/count/max/min (or any other aggregation) function.