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)
  • Use the below query to check which DPx/DSCPx application run and did not run

select * from [DYNASYS_ITF_SCo].dbo.SYS_TIMESTAMP
WHERE Table_Name in ('EXP_FORE_DR', 'EXP_FORE_AERO_DR')
and Type = 'TECH : Export Forecast Demand Review' and Source <> 'BW'
union 
select * from [ACEW1PDSCPAPPE5].[DYNASYS_ITF_ECo].dbo.SYS_TIMESTAMP WHERE Table_Name = 'EXP_FORE_DR'
and Type = 'TECH : Export Forecast Demand Review' and Source <> 'BW'
union
select * from [ACEW1PDSCPAPPE5].[DYNASYS_ITF_DSCP1].dbo.SYS_TIMESTAMP WHERE Table_Name = 'EXP_FORE_DR' 
and Type = 'TECH : Export Forecast Demand Review' and Source <> 'BW' 
GO

• • Check the timestamp to know the one(s) that are missing :
    • Before running again “Export DR flag”, check in DPx that no macro is being executed at the same time (for instance the Dynamic import)
    • If so, then connect to the missing application(s) to manually rerun the "AUTO_Export_DR_Flag" macro

• • when the macros has ended in the missing DPx, we must get the following situation (in this case, we just relaunched DP1 macro) :

• • Last action is to ask BW team to re-schedule a manual loading, so that the users can access refreshed data in BW reporting

To refer to :

> Timing between DynaSys DP <=> BW

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