Export Forecast Demand Review

• Macro = TECH : Export Forecast Demand Review
  • 06:00 CET in the batch “Export DR flag”
  • 13:00, 17:00, 22:00 CET in the batch “Export DR”
• It is executed first in DPx
• 4 times each day : 

• The objective is to fulfill the table EXP_FORE_DR that is extracted by BW
• the column app_name = dynasys_dpx allows to manage and to make distinction between data from all DP instances.
• the extraction from BW occurs at 07:00, 14:00, 18:00, 23:00 CET (it takes 45 min)
• data are available in BW reporting  half an hour later

• In case of problem, it is needed to coordinate with the BW team
• the batch to run again is “Export DR flag” (it is relative exclusively to the export of the demand review, the batch “Export DR” also executes additional exports between DP and DIP-PP)
• when the batch has ended in DPx, a manual loading can be executed in BW so that the users can access refreshed data in BW reporting

• Before running again “Export DR flag”, check in DPx that no macro is being executed at the same time (for instance the Dynamic import).

To refer to :

> Timing between DynaSys DP <=> BW <=> QV

Please refer to previous section: 2.5 - Import/ Export Timing

> List of Datafields (KPIs) send to BW

Please refer to previous section: 5.1 Dynasys => BW / QV