Versions Compared

Old Version 1

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Vincent Lapegue-EXT

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Added


Info
titleSupply Chain Excellence
Marie-Ange Carrier
Roberta Navone


Info
titleD&PS Expert
Miriam Luttrin
Donia Rachdi



General Description

In this indicator, we measure both by number and by value of eOrdering order lines against total number of Order lines. The indicator is split by eOrdering via Website, B2B and Manual order lines.
**Website refers to eOrdering via Solvay's eCommerce Websites (Solvay4Me & Rhodia eCommerce)
**B2B is refers to eOrdering via third party systems (example EDI, Elemica, and Quicklink)


KPI:

% E-Ordering (by volume, by value)


#E-Ordering

% Website

#Website

%B2B

#B2B

#Manual

This page displays the number of order and order lines created per month and split by type: Standard, Free, Samples, Return order lines.

KPI:

Number of Orders

Number of Order lines

Average number of Order Lines per Order



Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.


Calculation:


KPI Name
Calculation
#eOrdering
#E-Ordering
#B2B + #Website
%eOrdering
% E-Ordering
--------eOrdering
---------------------------------- x100
(#eOrdering + #Manual)
  
#Website
BI4:
Order Type = "Rhodia eCommerce - OMC" + "Rhodia eCommerce - Cust"
BW:
Order Type = WEB (via web Slv4me) + WEBC (SpP Webshop - CC) + EVMI (e-VMI)
%Website
% Website
----------# Website
---------------------------------- x100
(#eOrdering + #Manual)
  
#B2B
BI4:
Order Type = B2B
BW:
Order Type = B2B (Via e-business B2B) + DFUE (By telecommunication)
%B2B
% B2B
-------------#B2B
----------------------------------
(#eOrdering + #Manual)
  
Manual
#Manual
#Order Lines - #eOrdering
  
Value e-Ordering
BI4:
Currency Conversion:
Rate Month M = M*Rate Cumulative Month M - (M-1)*Rate Cumulative Month (M-1)
→ Pivot: euro
BW:
Currency Conversion: day
→ Pivot: euro


Technical Documentation

Source:

BW OBAS- BW_QRY_MVSDSO45_SD0006

BI4:

eCOMMERCE DASHBOARD_CWWPPS_R004
Tab: QlickView

Update:

Daily

Query filters applied:

Source Information:
BI4 Filters:
Image Removed
Image AddedORDER FLOW CODE = C OR
ORDER FLOW CODE = R AND SHIP TO KA <> GRCL200022/9999999999/GRCL000098
Image Removed
Image AddedDOC TYPE = KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/NB/UB
Image Removed
Image AddedORDER REJETION CODE = 98 OR EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)
Image Removed
Image AddedLEGAL COMPANIES <>ZFR9/7378
Image Removed
Image AddedDISTRIBUTION CHANNEL <> 8I
BW Filter:
Image Removed
Image Added[0COMP_CODE] COMPANY CODE <> 5711/5696/5672/5622/4058/3469/1428/1427/1426/1425/1419/0292
Image Removed
Image AddedReversal indicator <> R
Image Removed
Image Added[0DOC_TYPE] SALES DOC TYPE = KA/KB/KBCC/KE/LA/SB/T1/TD/TDIV/TDR/ZFAC/ZIND/ZITI/ZORB/ZOUT/ZRAG/ZRCM/ZRCS/ZSE1/ZSER/ZSIT/ATD/ZTDL/ZTDR/ZTES/ZVEX/ZVEY/ZVNO

Dimensions:

Global Overview of Dimensions





BWBI4
Global Filters
















PeriodMonth Year
Order Line Creation Month
Order document date YYYY/MM

Organization


GBU

[0G_CWWE01__CPFCTR1_2] GBU
GBU Name

Group of Activity

[0G_CWWE01__CPFCTR2_2] Group of Activities
BFC BU

Sub-Activity

N/A
BFC Market

Company

[C_COMPCDE] Company
Legal Company
PlantZone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Plant geographical zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant country
Plant
[C_PLANT] Plant
Plant name
Ship DestinationZone
[C_GZONE] Geographie/Zone
Ship to geo Zone name
Country
[C_SHIPTID__0COUNTRY] Ship-to country
Ship to country name
Corporate Group
[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship to group name
Ship Destination
[C_SHIPTID] Ship-to
Ship to name
ProductProduct Hierarchy
[C_PRODHIE] Product Hierarchy
N/A
Product
[C_MATNR2] Material\Attributes\[C_PROD] Commercial Product / Material Group
Product Name
Bulk/Packed
[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group
Mapping based on:
Material Packaging Group Name Bulk =
Packed in Bulk else = Packed
Packaging Type
[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Material Packaging Group Name
Specific Filters




Sales Office

Qv Mapping based on Sales Office
QV Mapping based on Sales Office

Sales Office Country

QV Mapping based on Sales Office
QV Mapping based on Sales Office

Sales Office

[C_SAL_OFF] Sales Office
Sales office name
CSR
[C_CUSTSAL__C_ZIPART] CSR (Sold-to)
Order partner ZI actualized name