Currency Management Model
Import
Data is imported from BW file DYS_BW_CURR for Y-3 to Y+3.
Note - for Composites:
- last imported value is propagated through the end of the horizon (Y+10) and;
- Y-4 values are kept.
Conversion Rate EUR → LCs
Conversion Rate is assigned from the CAR4 Currencies at <Any Level> level.
Then, this Conversion Rate is populated for all LCs available in DynaSys.
These data fields are used to updated the Unit of Measure Conversion in the hierarchy.
Conversion Rate EUR → Active L2
Each Conversion Rate EUR → LCs are summarized in Conversion Rate !EUR → !LC to update the Unit of Measure Conversion in the hierarchy and allow automatic conversion for all data fields.
Finally, the Conversion Rate !EUR → !LC (from structure) is fed by the hierarchy's conversion factor.
Master Data update
Create a new folder
Master data from the hierarchy
Duplicate the Master data from hierarchy datafield
> Forced
> Master data (final)
Add in the Static
Supersession Model
Configuration Data
The "Start Date Future" data field is automatically calculated based on the "Current Day" whereas the "Start Date Past" is blank (default value).
The "Replaced DFU" data field identifies the "old" DFUs (the unplanned DFUs).
The "Supersession OK to proceed" data field excludes DFUs with "#IND". If this value is found, the supersession is not applied.
The "Substituted Reference" data field is used by the users to set-up a supersession.
The "Substituted Reference Final" data field is the final output which is taken into account to apply supersession in data fields.
All the other data fields are core and used in all standard supersession calculations. In our model, we are taking the default value with no possibility of customization.
Technical Data
The "Disabled Self Supersession" data field identifies when there is a supersession from one DFU to the same DFU.
The "Final Items" data field identifies the remaining planned DFUs after the exclusion of Wrong Supersessions and before the exclusion of loop supersessions.
The "New Reference" data field identifies all planned DFUs after the exclusion of the Wrong Supersessions.
The "Old Reference" data field identifies all unplanned DFUs after the exclusion of the Wrong Supersessions.
The "Substituted Reference Corrected" data field takes into the set-up supersessions but excludes the Wrong Supersession (1 Old to N New).
The "Substituted Reference with Sequence" data field identifies DFUs part of a loop supersession (from DFU A → B, and then B → A).
The "Substituted Reference without Sequence" data field identifies planned DFUs which are not part of a loop supersession.
The "Wrong Supersession - 1 Old to N New" data field is an alert to detect if supersession has been set-up for 1 DFU to N DFUs, which can't go through with our model.
Input Data
Input Data are all data fields which need to be included in the supersession: forecast, budget...
Note: for Composites, a specific folder has been created to deal with the different UoM.
Output Data
Output Data are all data fields for which supersessions are included.
Daily Follow-up Data
Follow-up Data keeps track of all changes on a daily basis.
Technical Graph Summary
Here is a graph which summarizes the technical loop for Supersession Process: