Cumulative aggregation to specific day in a week

[former_member305977]

Hello IBP Experts,

We have a requirement to aggregate past and the current values on a specific day eg Monday. Please find the screenshot for values . Values in the Past ( 20 ) and Current ( 20 ) should be added to value on next Monday ( 200 ) . So the expected value on monday should be ( 20+20+200 = 240) and in the future the values should remain as is.

Is there anyway to achieve this without LCODE.

Regards,Uday

[Irmi_Kuntze · Accepted solution]

Hi Uday

yes there is, with the operator IBP_CAGGR, check on the details in the model configuration guide, pretty well described.

What you want to do in principle is for example:

1) have a calculated key figure that copies the values from your source KF1 to the target KF2, but only in the tome horizon you want to consider. You can control that with

IF(PERIODIDn - x >=$$PERIODIDnCU$$ ……

This is not necessary with 1908 any more as we have more parameter available to check the aggregation horizon.

2) Make sure that within that horizon the KF2 does not have any NULL values, easiest is to copy 0 into it

3) Create calculated KF3 in a way that NULL or 0 is set for every period, except the one where you want to display the value. If that is the current period, that would be something like

IF(PERIODIDn = $$PERIODIDnCU$$ , <formula> , 0 )

The <formula> now uses IBP_CAGGR and read KF2 with e.g.

KF3@PERPRODCUST= IBP_CAGGR( "KF2@PERPRODCUST",''SUM'', ''FORWARD'' , ''PASTCURRENT'')

There are other detailed modelling possibilities with different parameters, but they all use IBP_CAGGR in principle

If you want to display the values on e.g. every Monday, you need to determine how to identify a Monday. The easiest way is to have an attribute to the time profile for DAYS that sets a 1 for Monday, 2 for Tuesday etc, which you can then check when on daily level

Enjoy

Irmi

[former_member305977]

Hello Irmi,

Thanks for your response.

We were able to aggregate all the past and current values to the current bucket using IBP_CAGGR as you mentioned ( KF3@PERPRODCUST= IBP_CAGGR( "KF2@PERPRODCUST",''SUM'', ''FORWARD'' , ''PASTCURRENT'') ) .

Can you tell us how to aggregate that value to monday after setting 1 using attribute ?

Regards,Uday