General presentation
Objective of the application
Transaction created to upload and consult the GBR objects used by Finance, Global Sales and other reports.
Project BI4 Optimization (9584).
Usage information
The transaction is used by around 40 users in the worldwide split between corporate members and GBU users from Novecare, Aroma, Silica, Technology Solutions, Soda Ash, Peroxide, Special Chem, Coatis and Polyamides
History
The Global Business Repository (GBR) has been built some years ago with the objective to add reporting dimensions that were not managed as master data in SAP WP1 (like Customer Group, Market, Application, End-Use ). Some of the reporting dimensions are now used as well in PF1.
Technically speaking that was an Oracle database managed by specific tables dedicated to the purpose from image above.
It was thought in the context of BI4 (*) reporting and with the time these dimensions have been integrated in BW and QlikView dashboards
The QUIKLOAD was the tool responsible for getting the files tool used to load data in the GBR.
Different Functions are available and each one of them is specific for a type of data to be managed: customer groups, material groups, key-accounts, end-use … etc
Authorizations are managed bi BI4 team according to 2 levels:
by Function
by GBU
Roles & Access
Roles and access
The authorization are divided between access to the transaction code, type of function (corporate and/or GBU) and also by GBU permitted.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZBI_RCS_GBR_A01 | GBR– Global Business Repository - Corporate User | GBR– Global Business Repository - Corporate User |
| ZBI_RCS_GBR_A02 | GBR– Global Business Repository - GBU User | GBR– Global Business Repository - GBU User |
| ZR_*_CA_P05 | Check authorization for the GBU |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| ZCORPORATE | Corporate information |
| ZGBUUSER | GBU User |
| Z*P05 | GBU |
Dataflow overview
Project documentation drive folder:
https://drive.google.com/drive/folders/1j9kbzDh2WE9HiU4LF6c_wHq3tCg9rrUY
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
The transaction ZBW_GBR has in the background the program ZBW_SD_GBR.
There is possible by the first block of the information to check the user manual, where:
- User guide - the guide about the authorization request, load schema and the expected values for each function.
- Template - the template xls file for each function
- Queries - the core queries used by administration of the GBR objects on BW.
As mentioned by the authorization section, the type of function is split between the corporate users (left screen below), that allows to upload files for all function types and GBU, which it is only allowed to upload objects with the prefix 'GBU'.
Target objects in BW:
- Reference
- Corp. Cust. Group - C_GRCUST
- Corp. End-Use Application - C_GBR1
- Corp. End-Use Segment - C_GBR3
- Corp. End-Use Market - C_GBR2
- Corp. End-Use for GBU - C_GBR4
- GBU Segment - C_ENTSEG
- Assignment
- Corporate Cust. Groups (link) - DPCOPA06
- GBU Key Account - DPCOPA05
- GBU End-Use (link) - C_GBR24 (CS) / C_GBR14 (other GBU)
- GBU Customer Groups/ Sub-Groups - C_GBR10
- GBU Material Groups/ Sub-Groups - C_GBR18
- GBU Segment (link) - DBSDSO92 (CS) / DBSDSO93 (other GBU)
- GBU Zone (link) - C_GBUZONE
According to the GBU function selection, a new parameter with the check box option is open to check into the file the GBU filled and the user accesses.
The last box is regarding the directory from the .xls / .xlsx file and the buttons:
- Preview - To check the inconsistencies (in red) in the file, such as the corresponding messages
- Load - Once the check is ok, to get the file send it to AL11 directory /exploit/BW/GBR and trigger by event the corresponding process chain.
- History - To check the previously loads from each function ordered by the last change.
As it is possible to check in one of the records from previous screenshot, once the user fill the deletion flag during the upload, the attribute is erased from master data and this action is also reflected for others master data where the erased line is classified as attribute.
Other rules can be find in the functional document below.
Dependencies with other applications
For the PAX GBUs, we have the program GBR > BO, that gets valid data from GBU PX, PY and PV and send it to BO directory /exploit/BW/CIS by the program ZBW_GBR_BO with the parameters setted in the daily process chain PC_GBR_16.
Data loadings
Info providers and objects loaded
The list of process chains could be found in the application component DICO_PC_BW_GBR, where except the Send data to BO, the other chains are triggered on demand by the users on the ZBW_GBR tcode.
All steps inside the chain have a treatment for error message that send a e-mail to contact the support team doing reference of the chain with error.
Loading frequency
The load is triggered by the user via transaction ZBW_GBR
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | ~1 minute |
| ~ Average nb of rows loaded per load | ~100 |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution
Decommissioning of the chains/ objects using the PEP and DW2 as source is planned to be done before the project Go live.