You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Next »

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

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


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)

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


Contact IT

Alexandre Gastel (Houston, TEXAS) : application owner (contact Vanenburg for any need related to Mappy, by creating a ticket in JIRA)

Nicolas Brichler (Singapore) : data integration


What is loaded using Mappy ?

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


Sales Perimeter

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

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


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

https://mappy.solvay.com/login

or

via Sales-Force “My applications”


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 :


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 : Mappy - Novecare Commercial Data Cleaning

+

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