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 objects

List of authorization objects 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: CRDYN11, AACOPC01, AACOPC04 and CRSDSO02, CRSDSO42.

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.

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