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 |
|---|---|---|
| ZR_RCS_CA_M84 | Forward Looking ICM - Sales | Role Menu |
| ZBI_RCS_CO_A04 | Forward Looking ICM - Sales | Authorization objects |
Authorization variables
List of authorization variables mandatory for the application.
| Authorization variables | Object |
|---|---|
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
| V_C_PLANT_0012 | C_PLANT |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
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)
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
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| V_C_AUTHMA_0001 | C_AUTHMA | Authorization | No | Authorization Scope |
| V_C_PLANT_0012 | C_PLANT | Authorization with Input | No | Plant |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Authorization with Input | No | GBU |
| V_0CALMONTH_0059 | 0CALMONTH | Interval | No | Forecast Month |
| V_0CALMONTH_0062 | C_RUNPER | Interval | No | Run Period |
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_02 (COPC: TD - D - Sales Forecasts from Picaso)
- Execution of PC_COPC_03 (COPC: TD - D - Price Records Extraction Table (Solvay))
=> 2 minutes
- Execution of PC_COPC_03 (COPC: TD - D - Price Records Extraction Table (Solvay))
- Execution of PC_COPC_04 (COPC: TD - D - Price Records Extraction Table (Rhodia))
=> 5 minutes
- Execution of PC_COPC_04 (COPC: TD - D - Price Records Extraction Table (Rhodia))
- Execution of PC_COPC_06 (COPC: TD - M - Sales Unit Price / Quantity Forecast)
=> 30 minutes
- Execution of PC_COPC_06 (COPC: TD - M - Sales Unit Price / Quantity Forecast)
