General presentation
Objective of the application
The application loads OLAP BW Statistics data from all three BW system (HR and Rhodia BW data is loaded through excel file) to Solvay BW system. It loads data daily to update the BW object attributes like solman ID used for modification, changed date and changed by.
Main documentation:
List of contacts:
Guillaume THEVENET (SBS Information Services) : BW Team Lead
Abhishek KUMAR (SBS Information Services) : BW Technical Developer
Usage information
Around XX BW developers and change managers will be using it on regular basis to recognize the related queries.
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| None | ||
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| None | |
Dataflow overview
Functional and Technical rules on Workbench + Reporting
Dependencies with other applications
- It shares extractor (0TCT_DS01) with BI Statistics OLAP aggregation data
Data loadings
Info providers and objects loaded, Loading frequency and Average performance
- PC_ST_OL_01 - DAily data loading in BW. Every morning at 05:20 GMT+1. Duration 6 minutes.
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 6 min |
| ~ Average nb of rows loaded per load | 55,500 |
| ~ Total nb of rows loaded (if full) | 55,500 |
| ~ Average Runtime for 10k lines | 1.5 min |
Reporting
Queries End User Documentation
- Only one KPI which is Date difference = Core change date - Qlikview Change date.
Main queries
- BW_QRY_MVBWSTOL_0001
Broadcast
- None
Maintenance
Known bugs
- Solman ID not populated well, will be corrected soon.