Marie-Ange Carrier


Miriam Luttrin



General Description

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




  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


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
#B2B + #Website
%eOrdering
--------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
---------------------------------- x100
(#eOrdering + #Manual)
  
#B2B
BI4:
Order Type = B2B
BW:
Order Type = B2B (Via e-business B2B) + DFUE (By telecommunication)
%B2B
-------------#B2B
----------------------------------
(#eOrdering + #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:
ORDER FLOW CODE = C OR
ORDER FLOW CODE = R AND SHIP TO KA <> GRCL200022/9999999999/GRCL000098
DOC TYPE = KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/NB/UB
ORDER REJETION CODE = 98 OR EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)
LEGAL COMPANIES <>ZFR9/7378
DISTRIBUTION CHANNEL <> 8I
BW Filter:
[0COMP_CODE] COMPANY CODE <> 5711/5696/5672/5622/4058/3469/1428/1427/1426/1425/1419/0292
Reversal indicator <> R
[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