Hi All,
I would like to write an algorithm in DP (APO).
How to write the an algorithm program in APO>
Please let me know.
Regards,
Raju
Below is the requirement
Level of calculation:
Algorithm calculation is done at product * point of sales level.
Calculation periodicities:
Calculation could occur several times a day according to needs. It could be triggered automatically for process waves at fixed hours per country and triggered manually by client.
*Calculation logic:*
When the calculation is launched for a selection, the development should:
1. Check if values already exist in key figure set theoretical for the day calculation is launched. If so no calculation is ran otherwise the development moves to step 2
2. Check if a valid forced threshold value is maintained at product * point of sales combination for the day calculation is launched.
If so no algorithm calculation is ran and the development copy, for product * point of sales combination, the forced threshold value in a key figure named Theoretical Forced threshold replenishment order quantity otherwise the development moves to step 3
3. Check if product is assigned to a Products group. If so, this group will be considered in calculation step, otherwise, default product group will.
4. Check if point of sales is assigned to a Points of sales group. If so, this group will be considered in calculation step, otherwise, default point of sales group will.
5. Check if for each Products group * Points of sales group combination valid parameters values exist for the day calculation is launched. If so calculation is ran and the result is stored in a key figure named Theoretical replenishment order quantity otherwise Products group * Points of sales group combination is recorded in a log as an anomaly
Calculation results are saved into DP time series. For one product * point of sales * date combination, only one of these 2 key figures will contain a value.
Data and horizon used in algorithm
The algorithm calculation is done for the current day, based on real DP historical values of last 14 days and algorithm parameters.
DP historical values are stored in key figures set Validated (4 key figures: Sales, Rents, Transit and Stock)
Algorithm parameters are stored in tables described in previous chapter.
If there are missing data in the past for key figures set Validated, anyway the calculation is done.