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

How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site

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.

Authorization objects

List of autorisation objects mandatory for the application.

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

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:

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.

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

if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application

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

List the most important and complex queries only with a link to the documentation

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

Broadcast

Indicate if there are broadcasts and give some details on the broadcast settings.

Maintenance

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

Known bugs

Give the list and explanation on the known, not-solved, bugs.

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

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016