Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I never user data manager but you can take that as resident and necessary changes since you are not able to unlock the autogenerated script. try this if you ready to use
Load Dim1, Dim2, ..., If(DateField>=Max(DateField, -7) and DateField<=Max(DateField), Avg(Measure)) as Avg_Measure7Days Resident DataManager_Directory Group By Dim1, Dim2, ...;