Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Any idea?
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;
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.
So, when I want to add additional fields I would have to do this in a second resident load?