============================================================

============================================================


Summary 

Mappy analyze GBU's sales and with help of artificial-intelligence (AI), based on existing mappings,  it suggest new mappings for not mapped data.

Mappy is refreshed DAILY from BW and overwrites past recommendations (only the ones that have not yet been mapped by users) (Files are sent to GBR daily, at 00:09)

Mappy is interfaced with other systems where updates are automatically done (BW, SAP, Corporate Sales-Force CRM).


Contact IT

Paulo ALVES (PT): Application Owner (point of contact for any need related to  Mappy Web App managed by Vanenburg )

Jean Clavel (FR): Dataiku Team (Data Integration)


What is loaded using Mappy ?

  • GBR corporate customer groups links (RCS)
  • GBR ship-to KA  links
  • Channels links (Direct customer | Distributor | Trader | Service Provider)
  • GBR GBU End-Uses links
  • GBR GBU Segments links


Sales Perimeter

Data are extracted from the Global-Sales BW query based on order history: DI_BW_QRY_MVSDSO44_SD0002 (DI_QRY_MVSDSO44_SD0002) → DI = Dataiku prefix

WARNING ==> non SAP data are not included (Chemplex, Kimya)


The query is refreshed to take 6 months data :

  • from start date = 6 months earlier
  • to end date =current day


The BW query takes only :
- sales to final customer (no intra-sales)
- sales having a group of activity not null, and different than NA-Novecare
- sales with product and ship-to populated (if product/ship-to missing, GBR assignment impossible)
- sales having a sales employee (else Mappy is not able to know whom to assign for the update)

Access link

https://mappy.solvay.com/login

or

via Sales-Force “My applications”


Project Google folder

https://drive.google.com/drive/folders/12ESmswf19hgBM1t0kFRdBvWpU20VJz-W


File sent from Mappy to BW

MAPPY-file-for-BW.csv


GMD : Global Market Directors

GMD are the one that should assign END-USES and GBU-SEGMENTS in Mappy

There is one GMD by Group of Activity

Links between GMD and group of activities is managed using a GoogleSheet built like :


MAPPY servers

Production: https://mappy.solvay.com


Technical  Documentation


Loading BW→MAPPY : dataiku batch runs daily. Refresh happens overwrites past recommendations, only the ones that have not yet been mapped by users.

So as soon as new GBR mappings are reflected in BW, the corresponding suggestions will be removed from the list of mappy recommendations.


Loading MAPPY→BW : daily upload runs at 12:05 am GMT, but only when new validated data has been detected (that can happen during weekends if someone maps data on  Mappy  during their weekend).


Refer to MAPPY Wiki site : https://wiki.solvay.com/display/TECHREP/MAPPY

+

Mappy- Novecare Commercial Data Cleaning - Technical Documentation


Novecare Trainning

MAPPY has been implemented for Novecare GBU only (as key user for tests)

It is currently not used by other GBUs


Access :  https://mappy.solvay.com/login

or access via “My applications” in Sales-Force CRM Analytics


Sales-rep trainning


Sales-Rep user Guide



  • No labels