| Table of Contents |
|---|
...
GENERAL PRESENTATION
Objective of the application
COLMAR = C apex O verall L ifecycle M anagement A pprovals and R eporting
COLMAR is a tool to follow and forecast industrial projects for all GBU.
Tool Leader + IT leader of the application: francois.carette@solvay.com
Usage information
History
...
2023: To segregate data of Po2, authorization scope (C_AUTHMA) has to be added into project bundle (C_MA_PR). It is required to modify web portal, authorization application role, C_MA_PR object and BW queries
ROLES & ACCESS
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
...
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
This Colmar application will use composite roles, which contain many roles inside below
Composite Role | Role Name | M44 | M441 | A10 | A11 | A12 | A13 | A14 | A15 | A16 | A17 | A18 | A19 | A20 | M09 | ZBI_RCS_CO_A21 | ZBI_RCS_PS_A02 | ZR_TOUT_CA_P01 | ZR_TOUT_CA_P04 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ZC_RCS_COL_C01 | COLMAR - Administrator | X | X | X | X | X | X | X | X | ||||||||||
ZC_RCS_COL_C02 | COLMAR - IT Admin | X | X | X | X | X | X | X | X | X | |||||||||
ZC_RCS_COL_C03 | COLMAR - GBU Coordinator | X | X | X | X | X | X | X | X | X | X | ||||||||
ZC_RCS_COL_C04 | COLMAR - Reporting Plant | X | X | X | X | X | X | X | X | X | |||||||||
ZC_RCS_COL_C06 | COLMAR - Forecaster | X | X | X | X | X | X | X | X | X | X | X | X | ||||||
ZC_RCS_COL_C06_PAX | COLMAR - Forecaster - For PAX | X | X | X | X | X | X | X | X | X | X | X |
Authorization objects
For Colmar application, authorization objects will be in application roles
| Role | Role Name | Auth Obj | Family (C_MA_PR__C_FAMINPR) | GBU (C_BFCA_2__C_BFCA_4) | C_COMPCDE | Plant | Provider | C_AUTHMA (For Po2) |
| ZR_RCS_PS_A10 | RPSA10 - COLMAR - Forecast - Technical role | |||||||
| ZR_RCS_PS_A11 | RPSA11 - COLMAR - Reporting - Technical role | |||||||
| ZR_RCS_PS_A12 | RPSA12 - COLMAR - Data entry - Data scope | Z_IP_002 | $V_C_FAMINPR_32 | $V_C_BFCA_4_32 | All | $V_C_PLANT_32 | See provider sheet | $V_C_AUTHMA_32 |
| ZR_RCS_PS_A13 | RPSA13 – COLMAR - Data entry - Data scope - All | Z_IP_004 | All | All | All | All | See provider sheet | All |
| ZR_RCS_PS_A14 | RPSA14 – COLMAR - Reporting - Data scope | Z_IP_003 | $V_C_FAMINPR_33 | $V_C_BFCA_4_33 | All | $V_C_PLANT_33 | See provider sheet | $V_C_AUTHMA_33 |
| ZR_RCS_PS_A15 | RPSA15 – COLMAR - Reporting - Data scope - All | Z_IP_005 | All | All | All | All | See provider sheet | All |
| ZR_RCS_PS_A16 | RPSA16 – COLMAR - Display Master Data | Z_IP_006 | $V_C_FAMINPR_33 | $V_C_BFCA_4_33 | All | $V_C_PLANT_33 | See provider sheet | $V_C_AUTHMA_33 |
| ZR_RCS_PS_A17 | RPSA17 – COLMAR - Administrator master data maintenance | Z_IP_007 | $V_C_FAMINPR_32 | $V_C_BFCA_4_32 | All | $V_C_PLANT_32 | See provider sheet | $V_C_AUTHMA_32 |
| ZR_RCS_PS_A18 | RPSA18 – COLMAR - GBU dedicated master data maintenance | Z_IP_007 | $V_C_FAMINPR_32 | $V_C_BFCA_4_32 | All | $V_C_PLANT_32 | See provider sheet | $V_C_AUTHMA_32 |
| ZR_RCS_PS_A19 | RPSA19 – COLMAR - Trans GBU master data maintenance | Z_IP_007 | $V_C_FAMINPR_32 | $V_C_BFCA_4_32 | All | $V_C_PLANT_32 | See provider sheet | $V_C_AUTHMA_32 |
| ZR_RCS_PS_A20 | RPSA20 - COLMAR - Data online entry - Data scope | Z_IP_001 | All | All | All | All | All | |
| ZBI_RCS_CO_A21 | CBS Project costs Reporting Analysis - End User role | ZBI_CBS_PC | All | All | All | All | AREA_F_CO_CBS_PS | |
| ZBI_RCS_PS_A02 | Project Costs and Structures Analysis - End User role | ZBI_PS | N/A | N/A | All | All | CUB_WBS6 AREA_PSCO |
The application role will use class (user exit) to get the perimeter value of authorization objects, which get value from DSO DPIPCO15. This DSO is updated in Colmar Portal by Francois.
Variable detail gets from SM30 - ZBIU001_V_VAR
Display class = SE24 - ZCL_BIU001_COLMAR_AUTH
However, the normal perimeter roles such as Plant if it is assigned to a Colmar user as well, it will combine the access with the DSO DPIPCO15
For example, user KLMLUNG has authorization only for Novecare GBU and 2 plants 0263 and 0269 in the DPIPCO15 but he also have role ZR_RCS_CA_P02 to access all plants
As a result of this, he can access all plants with in Novecare GBU (CS) for BW query but this user can see the project only 2 plants in the Colmar portal
Embedded Google Drive File migrated true url https://drive.google.com/file/d/1zgmZ6SKCfM_PRAlnAsPpt5EKNsyeEsmbM0ePWaKFrWQ/view fullwidth true height 600
Detail of Colmar authorization
DATAFLOW OVERVIEW
...
Reporting documentation drive folder:
...
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
It is in menu role ZR_RCS_CA_M44
Main functionalities
Broadcast
Maintenance
| Embedded Google Drive File | ||
|---|---|---|
|
Documentation here
https://drive.google.com/drive/folders/1TibbQ_Tl69xv9m3S4syLYa-uQQ4j7je7
https://sites.google.com/a/solvay.com/colmar/home
Broadcast
There are some broadcasting as well but it is out of scope of BW support. The broadcasting is manage directly by Francois.
MAINTENANCE
Known bugs
- Colmar Folder missing in Portal WBP (BPJ)
the errors we found on BPJ portal server , were indicating problem in the backend system (WBP).
Sometimes when there are temporary bottlenecks/freezes on the backend, the connection from the portal gets lost, and it's necessary to restart the portal.
==> contact : Benelux MIM Support <bmimsupp@in.ibm.com> , CSC Belgium <CSCBE@be.ibm.com> ,
==> solution : restart BPJ
...
Recurring procedure
Planned Evolution
...