DP Stat Forecasting issue

[Former Member]

Hi All,

We came across the following issue recently:

The given product, location combination is designated to the selection used for AUTO model selection (strategy 56). So as expected, it is subjected to Auto Model forecasting. Please refer the screenshot below for better understanding:

We've based our forecasting on Corrected Sales History key figure (3rd key figure above, this is the key figure we reference in Historical Key figure in Univariate profile).

We thought that the forecasting model will read the Corrected Sales History key figure. However, when we run in background, it selects Croston method because it thinks that there are more than 66.67% zeros in historical data (which is not true as seen above).

Background job log:

However, when we run it interactively, it doesn't have 0 values in corrected history:

Can someone give us some inputs as to what is going on?

Following are the settings we have:

1) Corrected Sales History is macro calculated key figure (Sales History or Sales Adjustments)

2) Corrected History is system calculated key figure (as it is assigned in PA Admin > Extra > Forecast Settings)

3) We've not checked 'Read Corr. History Data from Planning Version' check box under Read Historical Data tab of Univariate profile

4) We do not have any outlier correction, set up for the Auto Model.

Thanks!

[former_member187488 · Accepted solution]

Hi,

First thought, is the corrected sales history key figure a liveCache key figure (instead of auxiliary key figure)? If yes, is the value saved to liveCache?
Please copy your data view without activating any macro, and check the data again. Only when you see data in a data view without macro, does it mean the data is really in liveCache.

BR, Ada

[Former Member · Accepted solution]

Hi Ada,

Thanks for your reply.

The Corrected Sales History Key Figure is a liveCache key figure (not auxillary).

The calculations are running fine with other product locations and as macro runs in background, it saves the calculated values.

Having said that, I will check and confirm if the values are really getting saved in liveCache.

Is there a way to view the liveCache values other than creating a different data view?

Thanks!

Best Regards,

Hiren

[former_member187488 · Accepted solution]

Hello

Create a copy of the data view is a best practice. In the copied data view, macros will be in inactive status automatically.
Please also make sure you're viewing the correct planning object as in the background run, avoiding reading data at aggregated level in interactive planning book.

BR, Ada

[emani_raghavendra]

Hello

Can you please check whether Read System Corrected History indicator was ticked in the Forecast Profile you were using ?

[Former Member]

Hi,

Ada - we created separate dataview without any macros. The Corrected Sales History key figure does have values. It is the system calculated Corrected History key figure that has a bunch of zeros in it.

Emani - No, it is not ticked in the Forecasting Profile. That's the reason we were wondering why it would behave so.

Surprisingly, this happened for only one location. Also, we ran the job in background thrice. The first time it showed weird results as discussed here. The second time, it generated right results. The third time again it showed weird results.

Not sure yet what is going on.

Thanks for inputs from you guys.