Access Management

Data Flow

Overview

Objective of the application

Actually it is not an application. They are three queries and they provide the following info

• BW COPA Netback query (Core Query) => Specific Netback figures used by controllers
• BW iCare query => Specific iCare figures used to feed Salesforce tool
• BW - BFC YTD Exchange rate monthly query (Core Query) => Specific Exchange rate figures used by controllers

Tool Leader + IT leader of the application: Reporting coordinator: Charlotte Rollier / Ludovic Depoix.

Usage information

• 27 users coming from COPA community => BW COPA Netback query (Core Query)
• 1 user coming from Salesforce community => BW iCare query
• All users coming from P&L community => BW - BFC YTD Exchange rate monthly query (Core Query)

Queries are in role menu: COPA - Netback, iCare, Exchange rate

History

These three queries have been create in WBP in the context of PQ1 Decommissioning project.

BW RTR - Exchange Rate Query (WBP)

No special info needs... it has been created under the DSO DAFICE01and it is fed daily, from the table TCURR of WBP.

Transformation DTS_TCURR WBP_400 -> ODSO DAFICE01 is used to load the exchanges rates and the second transformation ODSO DAFICE01 -> ODSO DAFICE01 to delete the exchange rates loaded before the current day.

Process chain: PC_FICE_00 - Daily - 1am.

BW RTR - Netback query (WBP)

It has been created under SpS project (P&L multiprovider => MVCOPA01)

In oreder to have more details of the multicube flow, rules and so on, please refer to the P&L documetation => Technical Documentation - RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)

Process chain where info provider CRCOPA22 is loaded: PC_COPA_PL_32 - Daily - 1:10 am.

BW iCare query

It has been created under SpS project (P&L multiprovider => MVCOPA01)

In oreder to have more details of the multicube flow, rules and so on, please refer to the P&L documetation => Technical Documentation - RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)

iCare Query uses severals providers in MVCOPA01:

CICC & Adjustment companies - P&L - Data → CRCOPA08
IM - RCS - CDSA w/ Program → CRCOPA32
IM - Solvay PF1 - GM Data → CRCOPA23
IM - Solvay PF1 - GM Data - allocation of transport costs → CRCOPA26
IM - Solvay PF1 - GM Data Annulation → CRCOPA30
NON-ERP - Below Gross Margin (BFC) → CRCOPA07
NON-ERP - Data → CRCOPA09
PAX: Profitability Analysis: COPA - IECRA Determination WP1 → CRCOPA29
PQ1 P&L - GM Data → CRCOPA10 (not longer loaded)
PQ1 P&L - PCA Data → CRCOPA11 (not longer loaded) 
Profit. Analysis: COPA - CDSA Program → CRCOPA31
Profitability Analysis: COPA - CDSA Determination → CRCOPA02
Profitability Analysis: COPA - IECRA Determination → CRCOPA01
Profitability Analysis: COPA - Solvay legacy → CRCOPA22
UPIS - Data → CRCOPA21

These providers are loaded in several process chains, (you can find the list of all providers loaded in P&L in this documentation):

Data Loading

Data Quality Control

Data come from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticity, workarounds and resolution plan.>

Roadmap

<List past & future evolutions for the application (including links to MED/FSD/TSD)>