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

Compare with Current View Page History

« Previous Version 19 Next »

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

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


Summary 

Mappy is refreshed DAILY from BW and overwrites past recommendations (only the ones that have not yet been mapped by users) with newer ones

(mappy takes daily data from the BW invoices query. As soon as new gbr mappings are reflected in BW, the corresponding suggestions are removed from the list of mappy recommendations)
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)

Mappy is loaded using a BW query "Historical invoices" (Global sales)
==> open orders with new product/material are not included
==> non SAP data (Chemplex, Kimya) are not included

GBR is loaded daily with data from Mappy

When a mapping is done directly in the GBR (without Mappy), Mappy is not updated and the corresponding mapping stays as "suggestion" in the tool


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
  • GBR ship-to KA  links
  • Channels links (Direct customer | Distributor | Trader | Service Provider)
  • GBR GBU End-Uses links
  • GBU GBU Segments links


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

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