3.1 - Source Descriptions

3.1.1 BW servers

WBP (BW production server):

Several BW queries are extracted on the server ACEW1PQLIKAPP02


XTRACT JOBBW QUERYCOMMENT 
TALEND_QV_BW_QRY_MVDYN11_0005 QV_BW_QRY_MVDYN11_0005 

we retrieve the last 2 years of data

UoM = VKG

TALEND_QV_BW_QRY_MVSDSO57_0003 QV_BW_QRY_MVSDSO57_0003 

we retrieve data of current and previous year

Intra GBU = '#'

TALEND_QV_BW_QRY_MVSDSO57_0001 QV_BW_QRY_MVSDSO57_0001 

we retrieve data of current and previous year

Intra GBU = '#'

TALEND_QV_BW_QRY_CPSDCH01_0001QV_BW_QRY_CPSDCH01_0001we retrieve data of current and previous year
TALEND_QVSCE_BW_QRY_MVSDTR01_0010QVSCE_BW_QRY_MVSDTR01_0010we retrieve data of current and previous year
TALEND_QVSCE_BW_QRY_MVSDTR01_0012QVSCE_BW_QRY_MVSDTR01_0012we retrieve data of current and previous year
TALEND_QVSCE_BW_QRY_MVSDTR01_0013QVSCE_BW_QRY_MVSDTR01_0013we retrieve data of current and previous year
TALEND_PROD_QVSCE_BW_QRY_MVSDSO51_0001QVSCE_BW_QRY_MVSDSO51_0001we retrieve data of current and previous year
TALEND_QV_BW_QRY_CPSDSO51_0001QV_BW_QRY_CPSDSO51_0001

we retrieve data of current and previous year.

UoM = VKG

TALEND_PROD_BW_QRY_MVSDSO45_SD0001BW_QRY_MVSDSO45_SD0001

we retrieve data of current and previous year

GBU = 'TS' and Intra GBU = '#'

TALEND_QV_BW_QRY_MVSDTR01_0011QV_BW_QRY_MVSDTR01_0011we retrieve data of current and previous year


Files are stored in the folder G:\XtractUniversal Talend Extraction for Talend remote engine to read them.


3.1.2 Salesforce

We retrieve information from Salesforce for the calculation of the Perfect Order Rate.

The connection is done using the sbs-is-appli-qlikview.support@solvay.com.crm service account.

The target system is : https://solvay-crm.my.salesforce.com/services/Soap/u/39.0

The following objects are extracted:

Salesforce objectFilter
CaseIsDeleted=false
RecordTypeIsActive=true
AccountIsDeleted=false
User
SLV_Involved_GBU__cSLV7_GCS_GBU__c!=null and IsDeleted=FALSE and RecordTypeId = '01224000000TaO2AAK'

3.1.3 Google Sheets

GSHEETS:

l


Responsible & contact points:

  •        Application Owner - Mathieu Pourqué
  •       Delivery Manager -  Donia Rachidi
  •       Project Manager - Vitaly
  •       Data Architect  - Joao Fonseca
  •       Tableau Dev -  Maxime Marboeuf
  •       Data Engineer -  Virgil Lissassi ; replaced by  Matteo Menghetti