#Horizon Roll
To monitor (all GBUs) if the Horizon Roll is shifted correctly.
| Application | Instructions | Screenshot |
|---|---|---|
| Dscp DPx / Dipx |
| NULL |
2. Open the Production RD Web portal |
| |
| 3. Input your user ID to get connected.(The User ID = Windows ID), no need to input Password. |
| |
| 4. In the ribbon, click on 'Explorer' |
| |
5. In Structure tab, open 'Horizons' under Structure → Horizons → Horizons → _Tech: Current Month Please find the Tech name in each application in below to check if the current month of each horizon is shifted to current month of the year. |
| |
DP1 | _Tech: Current Month |
|
| DP2 | Forecast month |
|
| DP3 | _Tech: Current Month |
|
| DiP1 | TECH : Current Month |
|
| DiP3 | TECH : Current Month |
|
#Batch Status
To monitor specific controls on batchs
Application | Instructions | Screenshot |
|---|---|---|
Dscp DPx / Dipx | To verify the batch status in SQL datahub of each application. To verify the current month in each application. To check if the monthly archive is created correctly in the application if needed. To check in SQL Datahub in COMMENT column to see if the TECH ends by 'ok'. | NULL |
DP1 | DP1 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
DP2 | DP2 - TECH : Horizon Rotation (get connection to SQL Server) |
|
DP3 | DP3 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
DiP1 | DiP1 - TECH : Horizon Rotation (get connection to SQL Server) |
|
DiP3 | DiP3 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
#Monthly Archive
To cross check the Monthly Archive
Application | How to Do | Screenshot |
|---|---|---|
| DSCP DP2 | DP2 - GBU - AERO - DP Monthly Archive (get connection to application DP2) *DP2 - Warn functional team in case of Dynamic batch not executed (DP : copy of gross history + stat calculation / DIP : inventories) |
|
| DSCP DiP3 | 1> Get connected to DSCP DiP3 2> Explorer → Structure → User models → U01 - NOVECARE → Archive template → MONTHLY ARCHIVE |
|
#Prod Server Logs
To cross check in Prod Server Logs if the sequence is executed correctly
Application | Instructions | Screenshot |
|---|---|---|
| DSCP DP1 | Check DP1 Dynamic import logs to see if copy of gross history of M-1 is correctly executed the 1st of the month. |
|
| DSCP DP3 | 1> Get connected to Prod Server Logs https://dynasys.syensqo.com/RDWeb/Pages/en-US/Default.aspx/LogsProduction folder: /Logs → PROD Server Logs |  |
| To check the statistical calculation launch into Dynamic Batch in DP3 on 1st of the Month. |
|
#Get connection to SQL Server
Application | Batch | Server name | Databases | SQL request |
|---|---|---|---|---|
Auto_Montly_Firstday → TECH : Horizon Rotation | asew1pdscpapp01 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp1' order by START_DT desc | |
| DSCP DP2 | AUTO_Daily_Static → TECH : Horizon Rotation | asew1pdscpapp01 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp2' order by START_DT desc |
| DSCP DP3 | AUTO_Monthly_FirstDay → TECH : Horizon Rotation | asew1pdscpapp01 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp3' order by START_DT desc |
| DSCP DiP1 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | asew1pdscpapp01 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dip1' order by START_DT desc |
| DSCP DiP3 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | asew1pdscpapp01 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dip3' order by START_DT desc |
#Export of Forecast to SAP (WP2) - TS
| Application | Instructions | Screenshot |
| DSCP DiP1 | DIP1 (TS) with forecast export to SAP - the 1st day of the month DiP1 - TECH : Export SAP TS |
|
| 2>> DynaSys Export Forecast to SAP WP2 (Transaction Code AL11) 2.1 files generated in SAP WP2 (Directory :/exploit/PP/data/DYN/FCST) |
|
|---|
