Rolling aggregation function

[uma_telugu]

Hi,

Did anyone try the new function IBP_RAGGR?

Activation fails if we use double quotes for SUM and PASTCURRENTFUTURE parameters treating them as key figures.

Using two single quotes or one single quote did not work. Activation fails with no detailed log.

AGGREGATEDDEMAND@PERPRODLOC = IBP_RAGGR ("DEMAND@PERPRODLOC" , "SUM" , -1 , 3 , "PASTCURRENTFUTURE")

Regards,

Uma

[former_member654033 · Accepted solution]

Hi,

I wrote with below syntax (2 single quote) and planning area is activated successfully, Please see below (You can copy paste syntax)

TEST@WKPRODLOC = IBP_RAGGR("INDEPENDENTDEMAND@WKPRODLOC",''SUM'',-1, 3,''PASTCURRENTFUTURE'')

Please try and let me know if this works.

Thanks

Girish

[former_member591269]

Hi Uma,

It seems you are using double quotes for 2nd (SUM) and 5th (PASTCURRENTFUTURE) Parameters.

I would suggest to use single quote for SUM and PASTCURRENTFUTURE and use double quote only for Demand Key Figure and it should work.

Please refer the below configuration.

Thanks & Regards,

Pradeep K C

[uma_telugu]

Thanks Girish & Pradeep.

Activation is successful today.

I tried using two single quotes for SUM and PASTCURRENTFUTURE before I posted this message. Planning area check is successful but activation failed. When I remove this calculation then planning area activation is successful. This is 2 days ago.

But today, I did not do any change, activation is successful now 🙂

--Uma