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:

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 CodeRole DescriptionExplanation
None  
   
   

Authorization objects

List of autorisation objects mandatory for the application.

Authorization objectExplanation
None 
  
  

Dataflow overview

https://drive.google.com/open?id=1HkoARBToDZ8S4Cn1acW3uuDgOQPI1YJ_8N1jjk-gyQo

Functional and Technical rules on Workbench + Reporting

Dependencies with other applications

Data loadings

Info providers and objects loaded, Loading frequency and Average performance

 

Key FigureEstimation
~ Average Process Chain Runtime6 min
~ Average nb of rows loaded per load55,500
~ Total nb of rows loaded (if full)55,500
~ Average Runtime for 10k lines1.5 min

Reporting

Queries End User Documentation

Main queries

Broadcast

Maintenance

Known bugs

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016