1.0 Access Management 


List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation

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:

    • End User rights
    • gives access to infoproviders of Infoarea "AREA_PSCO"
    • BI Analysis Authorization "ZBI_PS" ("*" for authorization objects not relevant for the application)

ZBI_RCS_CO_A21

CBS Project costs Reporting Analysis - End User role

Application Role:

    • End User rights
    • gives access to infoproviders of Infoarea "AREA_F_CO_CBS_PS"
    • Gives access to multiprovider:MPR_PS014
    • BI Analysis Authorization "ZBI_CBS_PC" 
Authorization ObjectsExplanation
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 ChainFinal Provider LoadingFrequencyTime startDuration