Add rolling month values in a QVD script

[#1]

Hi,

I need to create a QVD for one developer calculating rolling month aggregate values.

The mapping of the QVD is  :

IDField1,

IDField2,

Day,

Day_Quantity_Value,

Rolling_Month_Quantity_Value

Rolling_Month_M-1-Quantity_Value

Do you have any idea about the way to do it ?

I know this can be easily done in the chart expressions using set analysis but I need to have it already calculated in the qvd.

Thank you very much.

Younes

[#2]

Hi,

For your information and to precize my need :

1) in the DB I have a tab with the daily data (IdField1, IdField2, Day, Day_Quantity_Value)

2) I have a solution using a loop (for each row I sum the data in the DB table). Solution is OK but the performance is really awful (15 hrs processing for 55 000 rows.... !!!!)

If you have any idea, that would really be helpful