Objective

The objective is to deliver a Sales Costs query with Forecast prices in the next periods.

This query is used with Qlik in transparency Dashboards.

Sales data are coming from BW objects Dynasys, Picaso, and Order Book.

Roles & Access

Roles and access

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

Authorization variables

List of authorization variables mandatory for the application.

Dataflow overview

Source Layer

As showed in the data flow above the data source is a Main Calculation View CV_FMCO_QTY_SLS_FRC.

Below are the Calculation Views that make up the Main Calculation View CV_FMCO_QTY_SLS_FRC:

Dependencies with other applications

There is dependency on the following data flows.

Forecast sources :

DYNASYS - Reporting (Dynamic) : CRDYN11

Sales Forecasts from Picaso (Solvay) :  AACOPC01 and AACOPC04

Price Conditions :

Price Records Extraction Table (Solvay) : AACOPC02

Price Records Extraction Table (Rhodia) : AACOPC03

Sales Unit Price Forecast : APCOPC03

Alternative Units of measure for quantity conversion :

GENERATED DATASTORE OBJECT (UNITS OF MEASURE): UOMCMAT2

Order Book and Invoices sources :

SO Order Book: OPEN ORDER+SHIPPED NOT INVOICED (Solvay) : CRSDSO02

SO Order Book: OPEN ORDER+SHIPPED NOT INVOICED (Rhodia) : CRSDSO42

SO Global: Invoices (Solvay) : DBSDSO06

SO Global: Invoices (Rhodia) : DBSDSO46

Propagation Layer

Data Loading:

Infoprovider AACOPC05:

Loading frequency

Daily

Business Layer

Data Loading:

Infoprovider ABCOPC07:

Logic to retrieve the Sales Forecast Price:

Loading frequency

Daily

Virtual Layer

Composite Providers

CPCOPC07

Reporting (BW Query for Qlik)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A

Process Chains

Process Chains below must be added in a Meta Chain for an automatic run the 7th of each month.

Transparency extraction from BW is scheduled daily every morning.

Manual Loading procedure for a monthly Run:

Execution of 4 PCs directly from RSPC transaction (Starters are scheduled in Immediate mode).

• • Execution of PC_COPC_02 (COPC: TD - D - Sales Forecasts from Picaso)
    => 2 minutes

• • Execution of PC_COPC_03 (COPC: TD - D - Price Records Extraction Table (Solvay))
    => 2 minutes

• • Execution of PC_COPC_04 (COPC: TD - D - Price Records Extraction Table (Rhodia))
    => 5 minutes

• • Execution of PC_COPC_06 (COPC: TD - M - Sales Unit Price / Quantity Forecast)
    => 30 minutes