The new wiki link for this data flow is here:
Technical Documentation - COPA Netback, iCare, exchange rate queries
Please update the new doc there and no longer here.
| Table of Contents |
|---|
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
...
History
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 autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution
- 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)
History
These three queries have been create in WBP in the context of PQ1 Decommissioning project.
About
BW - BFC YTD Exchange rate monthly query (Core Query) => BW RTR - Exchange Rate Query (WBP) /!\ Obsolete /!\
no special info needs... it has been created under the DSO DAFICE01and it is fed daily, at 12:30AM, from the table TCURR of WBP.
About
BW RTR - Netback query (WBP) => BW RTR - Netback query (WBP) /!\ Obsolete /!\
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 => BW RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)
About
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 => BW RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)