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.

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