Not loaded since 2019
In Fixed costs analysis add budget information.
The objective is to upload budget from excel files.
Rtr team is the requester of this project (june 2018).
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
ZBI_RCS_CO_A24 | GBU Fixed Cost | Application role |
| ZR_RCS_CA_M53 | FC - GBU Fixed Cost | Role Menu |
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
C_RESP_CC__CPFCTR1_2 CPFCTR1_2 | ZR_*_CA_P05 |
C_RESP_CC__C_RPLANT C_PLANT C_COSTCTR__C_RPLANT | ZR_*_CA_P02 |
C_RESP_CC__C_AUTHMA | ZR_*_CA_P00 |
| C_COMPCDE__C_COMPPRS | ZR_*_CA_P07 |
| Company (C_COMPCDE) | ZR_*_CA_P01 |
Dataflow :
Datasource on a flat file → DSO → Infocube
Functional and Technical rules on Workbench + Reporting
09/19/2023: Last load of DSO → 04/23/2019
A Datasource on a flat file.
Mockup of source file :
DSO DBBUDG01 :
Be careful : in the key, they are BFC Global Business Unit and BFC Group of activities : in the mockup, only one line with one GBU but more BFC Group of activities.
Transformation between datasource DTS_CO_BUDGET_FIXED_COSTS and DSO DBBUDG01 :
It's an expert routine : - read table company for fiscvarnt
- add one line in DSO for each activity group not initial (to put a budget to 0 add activity group with value 0)
Transformation between DSO DBBUDG01 and Infocube CUB_FB001 :
Only direct mapping except : 0CALMONTH (Time characteristic conversion)
0CALQUARTER (Time characteristic conversion)
C_INFOPRO (constant name of DSO : DBBUDG01)
The loading run the process chaîn PC_FIXED_COST_BUDGET. This process chain is a direct scheduling with event "PC_FIXED_COST_BUDGET".
Loading on demand with transaction : ZBW_BUDGET_LOAD (program ZBW_LOAD_FLAT_FILE_BUDGET).
The user must create or modify a file data and chosse this file in the transaction.
| 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 |
Query:
BW_QRY_MPR_FC003_0008 is modified : add Calculated and Restricted key-figures.
Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts
Indicate if there are broadcasts and give some details on the broadcast settings.
Give the list and explanation on the known, not-solved, bugs.
List recurring procedures
Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016