General presentation

Objective of the application

The application loads data of the Plant Maintenance domain from ECC into BW, then calculate KPI which are loaded in Qlikview dashboard. It is also possible to consult the reporting on BO Analysis for Office.

Main documents for maintenance are :

<link>
<link>
...

Application<describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO>

Tool Leader + IT leader of the application: <name of project or main leader for the application + reporting coodinator>

Usage information

Around XX key users on BW and XXX end users on QV. The tools is used by five plants wolrdwide during the PoC and the initial deployment, and will be opened progressively to new plants.

Roles & Access

Roles and access

<list of application role + menu role> and explanation if we have several applications role with specials rules>

Authorisation objects

Plant

Company Code

Dataflow presentation

Overview

Functional and Technical rules on Workbench + Reporting

<detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way

Dependencies :

It shares extractors (2LIS_17_I3OPER, 0PM_OM_OPA_2/3) with the legacy PM application for RCS.
It shares texts of master data Notification and Work Order with PUNCH.
Some data is calculated in ECC every day at 23:00 GMT+1 before being loaded in BW.
Data is consumed by Qlikview dashboard. The loadings in QV are weekly and done on Monday at 06:00 GMT+1. One KPI is also loaded every day in QV.

Data loadings

Info providers and objects loaded

< detail of process chain, list + link between or special event done for the loading >

Loading frequency

Average performance

<if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube

The purpose is to give a general overview of the volume of data managed y the application>

Historization

We keep all the data in Up to Date DSO, and we keep only one year of history for Snapshots in DSO and cubes.

The deletion of old Snapshots is done in process chain based on a parameter from C_GBLFILT.

Reporting

Queries Documentation or user guide

List of core queries : https://drive.google.com/open?id=1EsXRHGQKTpAcor9U_eQGIWQN9igjArfbbhQ1Vxw3nUw

User documentation on calculation of KPI : <LINK>

Main queries

List of core queries : https://drive.google.com/open?id=1EsXRHGQKTpAcor9U_eQGIWQN9igjArfbbhQ1Vxw3nUw

Main functionnalities

User documentation on calculation of KPI : <LINK>

Broadcast

None

Maintenance

Known bugs

Recurring procedure

Procedure for errors during night data loadings : https://drive.google.com/open?id=17Kdo-zA7gCpfSK9LTNKBgw3tj1tpTukdxKPuMoHYYho

Planned Evolution

For deployment on new Plants :

Grant users authorizations for reporting in BO Analysis and QV.
Create jobs for calculation of KPI 2.4, 2.10, 2.15 and 2.16 in ECC if needed.