cancel
Showing results for 
Search instead for 
Did you mean: 

Process in restarting a FRP-run: how to prevent incorrect analytics data

Former Member
0 Kudos

Hi,

Today we encountered an issue where stock-data where not transfered to F&R. As a result OrderProposals generated during FRP-run were based on incorrect stock stock-values. As a result also the OrderProposals resulting from the FRP-run were considered incorrect and have been deleted by the business.

After stocks were processed correctly to F&R, a new FRP-run was done for the first 4 sequences in /FRE/FRP_MID_BASIC. (Note that we have these first 4 steps executed in the time critical window, and the Analytics step as a separate job directly afterwards).

Result is ofcourse new, correct, OrderPropsals but also a second run of the Analytics step on the same planning-day. As a result, in table /FRE/ANA_WEEKLY the STOCK_COUNTER is increased 2 times during one planning-day, which will cause incorrect data at the end of the week regarding average weekly-stock level.

It appears, every time the Analytics-step in /FRE/FRP_MID_BASIC is executed on a day, the STOCK_COUNTER field is updated. (this can be reproduced). The result will be incorrect Analytics data if that happens, but on the other hand: not executing the Analytics step a second time during the planning-day will also result in incorrect Analytics data as in that case it would in my situation have contained the stock-data from yesterday(as the initial issue was that current actual stock-data was not sent to F&R)

Is this a bug in F&R, or am I missing something? If there is a guide on what steps to execute under what conditions if FRP-run has to be executed again, or how to correct any (incorrect)Analytics data built up during previous runs?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

a reply/answer would be appreciated....

Former Member
0 Kudos

Think I found it myself: transaction /FRE/ANA_CLEANUP - F&R-analysedatabases opschonen (program /FRE/DB_ANA_CLEANUP) has a option to delete data from F&R Analytics tables, even if no data has been transferred to BI yet.

The documentation states the following:

Clean selected data not in BW: If you are transferring Analytics

data to BW and you need to delete data that has not yet been transferred to BW,

you have to check the option Clean selected data not in BW. This
options should be used in exceptional cases,
such as if  you need to rerun

FRP for a certain date for all your locations, because this report cleans

data for all the locations.

With the correct date-settings on the selection-screen of this transaction, the undesired Analytics data can be deleted, prior to the new FRP-run.

In all fareness it would a nice idea to have the FRP-run check when run in restart-mode (3 - Restart Without Error) whether or not Analytics data already exists, and issue a message that this Analytics data should be deleted first.(which practically may not be feasible since FRP-run and the 5th Analytics-step is usually run in background).

Alternatively, the FRP-run program could be changed (perhaps controlled via selection-option) to delete any Analytics that is already available for that planning-day on which the re-run takes place.

Answers (0)