Issue with actual data when we have data not published

[anthonysc]

Dear All,

We have an issue in an input schedule in SAC.

We have a column "Actuals" which is feeded by an import job from S/4 HANA. We have also an inputable column "Forecast" where users enter their forecasted amount.

Actuals data are imported every hours.

If we have data not published (user entered a forecasted amound and not published it), actuals data are not correctly displayed (it doesn't show the latest imported data).

Have you an idea of how to fix this issue ?

Thanks

Mat

[William_Yu · Accepted solution]

Is the Actual column and Forecast column referring to actual version and forecast version? 

Getting latest import of Actual version should not be impacted by un-published data in a different version. 

[anthonysc · Accepted solution]

Thanks for your feedback. No we have the same version and we use another dimension to distinguish Actual and Forecast (Dimension Process). Is there a way to fix it using one version only ?

thanks

[William_Yu · Accepted solution]

Ok, in this case, if you can enable DAC or data locking together with planning area, planning area will only be created on forecast data and keep actual data always up to date.

[anthonysc · Accepted solution]

thanks I will test that