| Table of Content Zone | ||||
|---|---|---|---|---|
|
Access Management
| Panel | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
List of application role + menu role and explanation if we have several applications role with specials rules.
|
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
List of authorization objects mandatory for the application.
|
2.0 DataFlow
2.1 Overview
Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
2.2 Technical Rules on Workbench
Explanation for the process on the technical side. Can be specific cases or general rules depending on the scope.
2.2 Dependencies with other applications
We should have the information where the application is sending or receiving information (e.g. APD open hub)
DataFlow
Overview
Detailed data flow (August 2023):
Widget Connector width 800 url https://docs.google.com/presentation/d/16tYtDx8BYcBFFLspA8nJSw9MDQuxW8k-t88GCPS4lSc/edit#slide=id.p1 height 800
Technical Rules on Workbench
FI-GL for CAPEX documentation
These flows contain all the FI-GL data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):
FI-AP documentation
These flows contain all the FI-AP data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):
It is part of Working Capital documentation:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
Fixed Asset Supplier (FAS) and Lease Interface
This requirement concerns CAPEX data but at detailled level so it was based on the existing Working Capital multiprovider on DSO (MVFIWC03).
More information about this solution, refer to the Working Capital documentation:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
BFC documentation
This flow contains BFC data used for the calculation of the CAPEX BFC key figures
It is part of Working Capital documentation:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
Cash Out documentation (PeC & Cash):
This flow contains FI data used for the calculation of the CAPEX Project key figures
Technical Documentation - Project Cost
Asset Accounting (BW RTR FI-AA)
The Asset Accounting (FI-AA) component is used for managing and supervising fixed assets with the SAP System. FI-AA was developed exclusively to meet IFRS16 requirements, however, it is being or will be used across Solvay for other requirements. Cubes related to AA have been develped and added to existing CAPEX Multiprovider (MVFICX01)
Flexible Real Estate Management (BW RTR RE-FX)
This requirement mainly related to IFRS16 (IFRS 16 is effective for annual reporting periods beginning on or after 1st January 2019) data where Solvay is now in position to extract RE-FX data as part of CAPEX reporting and hence RE-FX reporting cubes have been added to existing CAPEX Multiprovider (MVFICX01).
Reporting
Queries End User Documentation
RtR presentation:
https://drive.google.com/open?id=1SlcN2rzrL3F5IdQFSl_KtKYLnM_yvEuUZ67eEH6HQ5c
CKF and RKF explanations:
| Google Drive Live Link | ||
|---|---|---|
|
Main queries
| Query | Name |
|---|---|
| BW_QRY_MVFICX01_0009 | CAPEX L40800 Legal FA adjust. balances (Core Query) |
| BW_QRY_MVFICX01_0011 | CAPEX BFC Invest. data (Core Query) |
| BW_QRY_MVFICX01_0014 | CAPEX Invest. Project vs FI det. analysis (Core Query) |
| BW_QRY_MVFICX01_0015 | Capex Lease interface to BFC (Core Query) |
| BW_QRY_MVFICX01_0016 | CAPEX Lease B/S by Flows - Debt (Core Query) |
| BW_QRY_MVFICX01_0017 | CAPEX Lease B/S by Flows - REFX RoU (Core Query) |
| BW_QRY_MVFICX01_0018 | CAPEX Invest. Project to BFC synthesis (Core Query) |
| BW_QRY_MVFICX01_0019 | CAPEX Debt/RoU based on RE Act./Plan. Cash flow (Core Query) |
| BW_QRY_MVFICX01_0020 | CAPEX Future Cash flow for Budgeting (Core Query) |
| BW_QRY_MVFICX01_0021 | CAPEX Lease B/S by Flows - AA RoU (Core Query) |
| BW_QRY_MVFICX01_0022 | CAPEX Rolling Future Cash flow for L6605 (Core Query) |
| BW_QRY_MVFICX01_0023 | CAPEX Lease Colmar check (Core Query) |
| BW_QRY_MVFICX01_0024 | CAPEX Lease B/S by Flows - SAP vs BFC Debt (Core Query) |
| BW_QRY_MVFICX01_0025 | CAPEX Lease B/S by Flows - SAP vs BFC RoU (Core Query) |
| BW_QRY_MVFICX01_007 | CAPEX Colmar interface - Lease data (Core Query) |
| QV_BW_QRY_MVFICX01_0001 | CAPEX BFC FA+RoU for QS (Core Query) |
| QV_BW_QRY_MVFICX01_0002 | CAPEX SAP RoU for QS (Core Query) |
| BW_QRY_CPFICX02_0001 | CAPEX Lease GL extract for KPI automation (Core Query) |
Reports are available via workbooks published in the Roles menu.
Role menu "CX - CAPEX Analysis" (ZR_RCS_CA_M50)
Main functionalities
Complex formulas: most of the key figures definitions contains formula variables in order to calculate the "conso" view and use the "enlarge to PM" option.
Currency conversion: key figures are available in local currency but can be converted according to a target currency entered in a query prompt.
Dependencies with other applications
Data Loading
Info Providers and objects loaded
The lists of process chain are in subsections FI-GL for CAPEX, FI-AP, FI-AA...) .
3.0 Data Loading
3.1 Info Providers and objects loaded
Detail of process chain, list + link between or special event done for the loading
Main Process Chain | Final Provider Loading | Frequency | Time start | Duration |
|---|---|---|---|---|
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)>