Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have data at location,item and at day grain but in Ui i have to show the region average and loop and reduce at location level.
but when we are going to loop and reduce at location level , i cannot calculate the region average , thats need to be done at script level.
Do we have any function at script level that we can aggregate the value at region level for e.g in oracle we can use analytical function like SUM(sal) OVER (PARTITION BY deptno)
Hi,
And if you try in your preceding load statement :
load
sum(sal),
Dptno
resident SALES
group by Dptno ;