1.0 Access Management
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
ZR_RCS_CA_M09 | PS - Project Costs | Role menu for all project costs queries |
ZBI_RCS_PS_A02 | Project Costs and Structures Analysis - End User role | Application Role:
|
ZBI_RCS_CO_A21 | CBS Project costs Reporting Analysis - End User role | Application Role:
|
| Authorization Objects | Explanation |
|---|---|
| GBU (CPFCTR1_2 / C_RESP_CC__CPFCTR1_2) | |
| Responsible Plant | |
Responsible Plant (C_RESP_CC__C_RPLANT / C_COSTCTR__C_RPLANT) | |
| Authorization Scope (C_RESP_CC__C_AUTHMA) | ZR_*_CA_P00 |
| PRS Company code (C_COMPCDE__C_COMPPRS) |
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
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
- Remove old data: Only keep the 5 last years in the cubes in order to make the cube lighter and gain space in BWA.
- Fixed Cost project: A project is in progress to have fixed costs reporting by plant and GBU. This project will be finished end of july.
This project is a mix between CBS and COPA in order to provide fixed cost reporting by plant and GBU. The objective is also to replace actual fixed cost application for Rhodia legacy FC2.
For this project, we have created specific info areas
We have created MPR_FC003 for this purpose. This multi provider has same cubes as CBS application and one cube from COPA application.
For this multi provider we have 2 authorization object: C_RESP_CC__C_RPLANT Responsible Plant and C_RESP_CC__CPFCTR1_2.
We have also 3 new queries
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)
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 |
|---|---|---|---|---|