3.1 - Source Descriptions
3.1.1 BW servers
WBP (BW production server):
Several BW queries are extracted on the server ACEW1PQLIKAPP02
| XTRACT JOB | BW QUERY | COMMENT |
|---|---|---|
| TALEND_QV_BW_QRY_MVDYN11_0005 | QV_BW_QRY_MVDYN11_0005 | we retrieve the last 2 years of data |
| TALEND_QV_BW_QRY_MVSDSO57_0003 | QV_BW_QRY_MVSDSO57_0003 | we retrieve data of current and previous year |
| TALEND_QV_BW_QRY_MVSDSO57_0001 | QV_BW_QRY_MVSDSO57_0001 | we retrieve data of current and previous year |
| TALEND_QV_BW_QRY_CPSDCH01_0001 | QV_BW_QRY_CPSDCH01_0001 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0010 | QVSCE_BW_QRY_MVSDTR01_0010 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0012 | QVSCE_BW_QRY_MVSDTR01_0012 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0013 | QVSCE_BW_QRY_MVSDTR01_0013 | we retrieve data of current and previous year |
| TALEND_PROD_QVSCE_BW_QRY_MVSDSO51_0001 | QVSCE_BW_QRY_MVSDSO51_0001 | we retrieve data of current and previous year |
| TALEND_QV_BW_QRY_CPSDSO51_0001 | QV_BW_QRY_CPSDSO51_0001 | we retrieve data of current and previous year |
| TALEND_PROD_BW_QRY_MVSDSO45_SD0001 | BW_QRY_MVSDSO45_SD0001 | we retrieve data of current and previous year |
| TALEND_QV_BW_QRY_MVSDTR01_0011 | QV_BW_QRY_MVSDTR01_0011 | we 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.3 Google Sheets
GSHEETS:
- Rules > Qlikview (contains data used to compute ALLIANCE_VAL in job J100_PURCHASING_EXTRACT_SOURCE_
- DATA_HR_TARGET_2015
- SUPPLIER_UNDER_PANEL
- SUPPLIER_UNDER_PANEL_BENEFITS
- FUNCTION_COST_TARGET
- STRATEGY_TARGET
- MAPPING_GBU
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