You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

General presentation

Objective of the application

This application extract the forecasts from the application APO. The data is loaded and aggregated in BW and made accessible through a multiprovider which regroups data from three application. APO, Dynasys and Logility. In time, application Logility will be terminated and the data coming from APO should be integrated in Dynasys.

Tool Leader + IT leader of the application: Celia Gonzales

Usage information

History

Golive In May 2017

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with special rules.

This should be the same as what's done for Dynasys.

Role CodeRole DescriptionExplanation
ZR_RCS_CA_M52 DP - Demand Planning

Role Menu Dynasys (APO uses the same queries)

Currently (Nov 2016), only 2 queries published in this role

ZBI_RCS_DP_A02Demand Planning - Dynasys

Role utilisateur Dynasys

Authorization object ZBI_DPS

  • gives access to Application Area IA_DPS_DYNASYS
  • authorization limited on GBU (CPFCTR1_2) (in WBP since 14/03/2017)
ZBI_RCS_DP_A03Demand Planning - Dynasys Keyuser

Authorization object  ZBI_DPS_K

  • gives access to transaction ZMAINT_MATPLANT + ZMAINT_MATVENDOR
  • gives access to Application Area IA_DPS_DYNASYS 
  • authorization limited on GBU (CPFCTR1_2) (in WBP since 14/03/2017)

Authorization objects

List of autorisation objects mandatory for the application.

This should be the same as what's done for Dynasys.

Authorization objectExplanation

GBU (CPFCTR1_2)

ZR_*_CA_P05

Dataflow overview


Reporting documentation drive folder:

https://drive.google.com/open?id=0BxkySrtHryoBeG05a0ljVWJpSmM

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

1 : Cleaning of incoming data before propagation datastore objects

C_MATNR2: adjust the format of the material number to the right number of digit, adding/removing zeros in the process.

0LOGSYS : Determination of system source

C_SHIPTID & C_SOLDID (only for Special Chemical): Removing of source system extension and adjustment of the format 

2 : Determination of previous period for C_FCSTMTH when loading the snapshots

It's usually the previous month. It can however be fixed to a specific value through the use of filters in masterdata C_GLBFILT

3 : Loading of attributes from MD for all DSOs

  • BFC Global Business Unit (CPFCTR1_2) is retrieved from the corresponding attribute of Material Plant (C_MATPNT2).

C_MATPNT2 is determined through the coupling of material and plant and is used for business assignments (ERP or BFC). It contains multiple attributes mainly loaded through either the standard attributes from datasource 0mat_plant and the MD C_SUBACT2 (a mix of Profit center (WP1) and Business area (PF1, PI1 and RHO systems)).

  • Customer Group - Enterprise (C_CUSTGRP) is retrieved from the corresponding attribute of Customer - Enterprise Axis (C_CUSTENT).
  • Company code (C_COMPCODE) is retrieved from the corresponding attribute of Main Shipping Plant (C_MPPLANT).
  • Sales Office (C_SAL_OFF) and Sales Document type (C_DOCTYP2) have been initialised with value APO.

4 : Loading of attributes from MD for loading coming from RCS (Every DSO except the two for Special Chemicals)

  • Division (0DIVISION) is retrieved from the corresponding attribute of Material (C_MATNR2).
  • Sub-Activity (0G_CWWE01), also known as Iecra, is retrieved from the corresponding attribute of Technical GBR Deter CDSA Payer (C_CDSA).

C_CDSA contains the distribution channel coupled with division. The IECRA can also be found in C_MATPNT2, but it's value is wrong.

5 : Loading of attributes from MD for loading coming from SOLVAY (Only the DSO for Special Chemicals)

  • Material Group (C_MAT_GRP) is retrieved from the corresponding attribute of Material (C_MATNR2).
  • Ship-To-Country (C_SHTCTRY) is retrieved from the corresponding attribute of Ship-To-Party (Core) (C_SHIPTID).
  • Sub-Activity (0G_CWWE01) is retrieved from the corresponding attribute of Material Plant (C_MATPNT2).

IECRA is specified in this dataflow as an information but is not reliable. IECRA is not an organizational structure used in Solvay.

  • Commercial Product/Material Group (C_PROD) is retrieved from the corresponding attribute of Material (C_MATNR2).

Commercial Product for RCS and Material Group for Solvay

6 : Keyfigures in summation when loading the business datastore objects

Data in APO can't really be aggregated in a DSO as every characteristic is key (like in an infocube). This means that the semantic keys which were determined for the propagation level is not absolute. Since the DSO are in write optimized, there is no loss of data thanks to the techical keys. It is necessary however to load the key figures in sommation at business level.

7 : Determination of Concerned Period (C_FLGMTH) for dynamic dataflow

We are always loading data for current month M

8 : Determination of Concerned Period (C_FLGMTH) for snapshot dataflow

The month view is determined depending on the difference between the period 0CALMONTH of the forecast and the considered period C_FCSTMTH (date of the photo).

IF 0CALMONTH = C_FCSTMTH THEN C_FLGMTH = 'M'

ELSE IF 0CALMONTH > C_FCSTMTH THEN C_FLGMTH = 'M-2, M-3,...' (There is no M-1)

ELSE C_FLGMTH = 'N/A'

Examples:

Calendar Year/Month

(0CALMONTH)

End of Month View

(C_FCSTMTH)

Concerned Period (Flag)

(C_FLGMTH)

07.201707.2017M
02.201907.2017M-20
08.201607.2017N/A

9 : Determination of GH quantity and bias for snapshot dataflow

For each snapshot loaded in a business datastore object, we rework the entire datastore object. We update the Gross History quantity for past snapshots using the latest GH quantity depending on the keys of the DSO.

There is 3 bias which are calculated:

  • The bias for the final forecast is calculated through the following:  ABS ( FF Quantity - GH quantity).
  • The bias for the sales team forecast is calculated through the following:  ABS ( STF Quantity - GH quantity).
  • The bias of the statistical forecast is calculated through the following:  ABS ( STATF Quantity - GH quantity).

Dependencies with other applications

This dataflow is using the same multiprovider than the dataflow for dynasys. Therefore when modifying multiprovider MVDYN11, beware of the impacts.

The loading of the snapshot part is done on the same day than dynasys.

Data loadings

Info providers and objects loaded

There is a high volume of data for the snapshot dataflow, which is why a clean-up was established during the loading in the PC. We keep only 36 months of history. The deletion process is done on every layer.

As the snapshot and dynamic dataflow use the same source, a decision tree was used to stop one loading if the other is already on-going.

Id

Description

TypeFrequencyComments
PC_APO_17META - D - APO - Current period and future periodsMasterDailyMaster Chain for dynamic forecasts
PC_APO_11TD - D - APO - Propagation Layer - Current and future periodMasterDailyLoading of the propagation layer for dynamic forecasts for every sources
PC_APO_01TD - D - APO - PL - Sp & Ch / Rare Earth - Cur. and Fut. PerSingleDailyLoading of dynamic forecasts for Specialty Chemicals / Rare Earth
PC_APO_02TD - D - APO - PL - Novecare - Current and Future PeriodsSingleDailyLoading of dynamic forecasts for Novecare
PC_APO_05TD - D - APO - PL - Polyamide Downstream - Cur. and Fut. PerSingleDailyLoading of dynamic forecasts for Polyamide Downstream
PC_APO_07TD - D - APO - PL - Polyamide Upstream - Cur. and Fut. PerSingleDailyLoading of dynamic forecasts for Polyamide Upstream
PC_APO_09TD - D - APO - PL - Special Chemicals - Current and Fut. PerSingleDailyLoading of dynamic forecasts for Specialty Chemicals
PC_APO_23TD - M - APO - Business Layer - Current and future periodsMasterDailyLoading of the business layer for dynamic forecasts for every sources
PC_APO_25TD - D - APO - BL Novecare - Current and future periodsSingleDailyLoading of dynamic forecasts for Novecare
PC_APO_26TD - D - APO - BL Polya. Downst - Current and future periodsSingleDailyLoading of dynamic forecasts for Polyamide Downstream
PC_APO_27TD - D - APO - BL Polya. Upstr - Current and future periodsSingleDailyLoading of dynamic forecasts for Polyamide Upstream
PC_APO_14TD - D - APO - BL Sp & Ch / Rare Earth - Current and fut perSingleDailyLoading of dynamic forecasts for Specialty Chemicals
PC_APO_21TD - D - APO - BL Special Chemicals - Current and future perSingleDailyLoading of dynamic forecasts for Specialty Chemicals
PC_APO_15TD - D - APO - Reporting Layer - Current and future periodSingleDailyLoading of the reporting layer for dynamic forecasts for every sources
PC_APO_40MD - D - APO - Master DataSingleDailyLoading of APO master data
PC_APO_18META - M - APO - SnapshotsMasterMonthlyLoading of APO Snapshots
PC_APO_12TD - M - APO - Propagation Layer - SnapshotMasterMonthlyLoading of snapshots for every sources in the propagation layer
PC_APO_01TD - M - APO - PL - Special Chemical / Rare Earth - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals / Rare Earth
PC_APO_02TD - M - APO - PL - Novecare - SnapshotSingleMonthlyLoading of snapshots forecasts for Novecare
PC_APO_05TD - M - APO - PL - Polyamide Downstream - SnapshotSingleMonthlyLoading of snapshots forecasts for Polyamide Downstream
PC_APO_07TD - M - APO - PL - Polyamide Upstream - SnapshotSingleMonthlyLoading of snapshots forecasts for Polyamide Upstream
PC_APO_09TD - M - APO - PL - Special Chemicals - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals
PC_APO_24TD - M - APO - Business Layer - SnapshotsMasterMonthlyLoading of snapshots for every sources in the business layer
PC_APO_28TD - M - APO - BL Novecare - SnapshotsSingleMonthlyLoading of snapshots forecasts for Novecare - Deletion of snpashots older than 36 months
PC_APO_29TD - M - APO - BL Polyamide Downst - SnapshotsSingleMonthlyLoading of snapshots forecasts for Polyamide Downstream - Deletion of snpashots older than 36 months
PC_APO_30TD - M - APO - BL Polyamide Upstream - SnapshotsSingleMonthlyLoading of snapshots forecasts for Polyamide Upstream - Deletion of snpashots older than 36 months
PC_APO_22TD - M - APO - BL Special Chemicals - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals - Deletion of snpashots older than 36 months
PC_APO_13TD - M - APO - BL Special Chemicals / Rare Earth - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals / Rare Earth - Deletion of snpashots older than 36 months
PC_APO_16TD - M - APO - Reporting Layer - SnapshotMasterMonthlyLoading of snapshots for every sources in the reporting layer
PC_APO_33TD - M - APO - RL Novecare - SnapshotSingleMonthlyLoading of snapshots forecasts for Novecare - 6 months of history
PC_APO_34TD - M - APO - RL Novecare - Snapshot HistorySingleMonthlyLoading of snapshots forecasts for Novecare - 7th to 32 months
PC_APO_35TD - M - APO - RL Polyamide Downstream - SnapshotSingleMonthlyLoading of snapshots forecasts for Polyamide Downstream - 6 months of history
PC_APO_36TD - M - APO - RL Polyamide Downstream - Snapshot HistorySingleMonthlyLoading of snapshots forecasts for Polyamide Downstream - 7th to 32 months
PC_APO_37TD - M - APO - RL Polyamide Upstream - SnapshotSingleMonthlyLoading of snapshots forecasts for Polyamide Upstream - 6 months of history
PC_APO_38TD - M - APO - RL Polyamide Upstream - Snapshot HistorySingleMonthlyLoading of snapshots forecasts for Polyamide Upstream - 7th to 32 months
PC_APO_20TD - M - APO - RL Spec Chem / Rare Earth - Snapshot HistorySingleMonthlyLoading of snapshots forecasts for Specialty Chemicals / Rare Earth - 7th to 32 months
PC_APO_31TD - M - APO - RL Special Chemicals - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals - 6 months of history
PC_APO_32TD - M - APO - RL Special Chemicals - Snapshot HistorySingleMonthlyLoading of snapshots forecasts for Specialty Chemicals - 7th to 32 months
PC_APO_19TD - M - APO - RL Special Chemicals / Rare Earth - SnapshotSingleMonthlyLoading of snapshots forecasts for Specialty Chemicals / Rare Earth - 6 months of history
PC_APO_39TD - M - APO - Deletion of old photos from propagation dsoSingleMonthlyDeletions of snapshots older than 36 months

Loading frequency

There is two master PC:

  • The loading of the dynamic data is done once a day
  • The loading of the snapshot data is done on the 6th of each month

Average performance

 

Key FigureEstimation DailyEstimation Monthly
~ Average Process Chain Runtime~1h305h
~ Average nb of rows loaded per load
  • Propagation layer:
    • 4 millions for novecare
    • 1 million for polyamide Upstream
    • 200000 for Specialty chemicals / rare earth
    • 2.5 million for polyamide Downstream
    • 400000 for Specialty chemicals
  • Reporting layer:
    • 800000 for novecare
    • 200000 for polyamide Upstream
    • 40000 for Specialty chemicals / rare earth
    • 500000 for polyamide Downstream
    • 280000 for Specialty chemicals
  • Propagation layer:
    • 12 millions for novecare
    • 3 million for polyamide Upstream
    • 550000 for Specialty chemicals / rare earth
    • 7 million for polyamide Downstream
    • 700000 for Specialty chemicals
  • Reporting layer:
    • 2.3 millions for novecare
    • 600000 for polyamide Upstream
    • 110000 for Specialty chemicals / rare earth
    • 1.4 millions for polyamide Downstream
    • 550000 for Specialty chemicals

Record Keeping

36 Months of history

DSO Backup

The DSO DBAPO012 is available if necessary to backup the data of a dso on business layer. This is used especially when there is a need to change the structure of a core DSO. Data must be backed up DBAPO012 before modification of a dso structure, then reloaded from DBAPO012 to datastore after modification.

Reporting

Queries End User Documentation

See Query definition under Dynasys.

 

Main queries

Main functionalities

Broadcast

Maintenance

Beware of the impacts when working on the multiprovider or the queries, as they are also used by Dynasys.

Known bugs

The sommation for the key figures coming from special Chemicals is not done. 

Recurring procedure

Planned Evolution

 

  • No labels