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

Compare with Current View Page History

« Previous Version 7 Next »




Process Owner

Jose-Ignacio Patino

D&PS Expert

Ayoub Kadioui - Stéphane Bourgeaud-lignot



This page describes all the manual actions regarding the following manual actions and mappings : 

  • Add / Remove / Modify Customers
  • NPS Results

Add / Remove / Modify Customers


The GSKA Dashboard entry point IS the customers, based on customer group level. To add (or remove) a customer the different steps are described below.
Warning : in the flat files ( mapping, data sources, ...) it is mandatory not to change sheet names, column names, neither adding or removing columns. Such actions can prevent the correct loading in the dashboard and therefore can break the WHOLE loading of the dashboard (not only the given data / mapping).
ActionWho requests ?Who does ?

1) Add the customer to the following file : GSKA List (GSKA Definition tab), with Label (mandatory), PF1 Corporate group code (mandatory), WP1 Corporate group code (optional, if customer is also on WP1).

Excellence CenterSBS D&PS (project) - Excellence Center (maintenance)
2) If the customer has ShipTo / SoldTo in non-ERP systems, add the non-ERP ShipTo / SoldTo to the same file (Group Mapping tab), so they are linked to the PF1 / WP1 corporate groups and therefore to GSKA definition.Excellence CenterSBS D&PS (project) - Excellence Center (maintenance)

3) Check with the involved GBUs that the Corporate ShipTo Group, Corporate SoldTo Group contain the proper ShipTo and SoldTo Accounts.

Excellence CenterGBUs

4) Check with the involved GBUs that the ShipToKA are correctly maintained.

Excellence CenterGBUs
5) Check with Customer Credit and Trade (CCT) team that the payer group for the customer is correctly defined and that the Corporate Payer Group code is aligned to PF1 Corporate Group.Excellence CenterGBUs

6) Populate data in manual sources (NPS for instance) based on the PF1 Code.

Excellence CenterExcellence Center

NPS results


The NPS results by Customer (SoldTo Group) are loaded from a flat file (Google Spreadsheet).
Warning : in the flat files ( mapping, data sources, ...) it is mandatory not to change sheet names, column names, neither adding or removing columns. Such actions can prevent the correct loading in the dashboard and therefore can break the WHOLE loading of the dashboard (not only the given data / mapping).

ActionWho requests ?Who does ?

1) Prepare the results from NPX tool to match the Spreadsheet template

Excellence CenterExcellence Center
2) Copy / Paste the new results in the "Data" sheet of the flat file, below the previous resultsExcellence CenterExcellence Center

3) The day after, check the correct loading in the dashboard

Excellence CenterExcellence Center

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels