Disaggrgate Stat Forecast out put key figure value based on another key figure

[prasad_mandre]

Hello Experts,

We store out put of Forecasting Model in Statistical Forecast key figure.

We want to disaggregate this output based on another key figure value in different time bucket. e.g. 24th Month Statistical forecast should be disaggregated based on value in 12th Month Demand KF. If 0 on 12th month Demand KF then don't disaggregate. If there is value in 12th month Demand Forecast then disaggregate based on that value.

I tried to maintain disaggregation expression in Statistical Forecast KF but didn't worked. Any idea how to disaggregate based on value other KF value in another time bucket?

Thanks in advance.

[piyush_parekh · Accepted solution]

Hi,

You can use attribute transformation to bring 12th month demand KF values in 24th month. The target key figure then needs to copied to another stored key figure "KF2". Use this stored key figure in the disaggregation expression of Statistical Forecast KF with appropriate conditions.

For e.g. Use KF2 for disaggregation, if it's NULL, use Statistical Forecast KF itself. Here, disagg expression would be IF(ISNULL(KF2), Statistical Forecast KF, KF2)

Please go through disagg expression section in Model Config. Guide to get further details on how to use disaggregation expression and pre-requisites.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1908/en-US/1b6b2555815e743ce10000000a17...

Regards,

Piyush

[prasad_mandre · Accepted solution]

Hi Piyush,

Thanks for your response. Above option is helpful but I used another simpler one - Copy operator using Period offset and using new copied store key figure for disaggregation. Testing it further. Thanks

Prasad