General presentation
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 hain: PC_FICE_00 - Daily - 1am.
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)
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)