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.

Role Code	Role Description	Explanation

Authorization objects

List of authorization objects mandatory for the application.

Authorization object	Explanation
C_AUTHMA	Authorization Scope

Dataflow overview

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_10-40-20.png

Source Layer

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

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_11-39-35.png

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

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_11-42-3.png

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_11-43-4.png

Dependencies with other applications

There is dependency on the following data flows: CRDYN11, AACOPC01, AACOPC04 and CRSDSO02, CRSDSO42.

Propagation Layer

Data Loading:

Infoprovider AACOPC05:

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_12-24-37.png

Loading frequency

Daily

Business Layer

Data Loading:

Infoprovider ABCOPC07:

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_12-29-59.png

Logic to retrieve the Sales Forecast Price:

Loading frequency

Daily

Virtual Layer

Composite Providers

CPCOPC07

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_12-34-58.png

Reporting (BW Query for Qlik)

Description	Sales Revenues Forecast Snapshot
Technical Name	QV_BW_QRY_CPCOPC07_0001
Application	COPC
Info-provider	CPCOPC07
Usage type	Qlik Source
Expected users

Global properties

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-3-17_12-39-53.png

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation
V_0CALMONTH_0062	C_AUTHMA	Authorization	No	Authorization Scope
C_PLANT02	C_PLANT	Select Option	No	Plant
CPFCTR1_2_0001	CPFCTR1_2	Select Option	No	GBU
V_0CALMONTH_0059	0CALMONTH	Interval	No	Forecast Month
V_0CALMONTH_0062	C_RUNPER	Interval	No	Run Period

Variable Sequence

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-7-26_17-57-36.png

Filters

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-7-26_17-58-5.png

Key figures

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-7-26_17-58-24.png

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-10-3_9-45-49.png

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-10-3_9-46-28.png

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-10-3_9-46-55.png

Characteristics

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-8-1_15-47-16.png

TECHNO - BI TEAM > Sales Revenue Forecast > image2022-10-3_9-44-4.png

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