SCE Dashboard - HOTD

HOTD (Haulier On Time Delivery) evaluates the performance of hauliers.

This indicator compares the real arrival date to the planned one.

			HOTD
			TIERS QVSCE_BW_QRY_MVSDTR01_0012
Global Filters	Period	Month Year	Ship Actual for Ship [C_SHIPNU2__C_COMPMON]
	Geography	Zone	Ship Dep Geo Zone [C_PNTDP3__C_ZONE]
	Geography	Country	Ship Dep Country [C_PNTDP3__0COUNTRY]
	Organization	GBU	BFC GBU [C_SUBACT2__CPFCTR1_2]
		Legal Entity	Company code [C_COMPCDE]
		BU	BFC Group of activity [C_SUBACT2__CPFCTR2_2]
		Site	Purchasing Site [C_PLANT__C_PSITE]
Specific Filters	Transportation	Transport Mode	Ship Transportation [C_SHIPNU2__C_TR_MODE]
		Forward Agent	Forward Agent [C_FWDAGID]
		Sea line	Ship Shipping Line [C_SHIPNU2__VTADD01]
	Destination	Ship Dest Point	Ship Destination Point [C_PNTDS3]
		Ship Dest Country	Ship Dest Country [C_PNTDS3__0COUNTRY]
		Ship Dest Zone	Ship Dest Geo Zone [C_PNTDS3__C_ZONE]

Reference date:

Actual Shipment completion date

KPI:

HOTD

Comments:

Currently there is no value of data quality (= % shipments with a real arrival date) for HOTD in the dashboard but it can be found in TIERS. In the core query, we can find this value of data quality under the name of Number of shipments relevant for transit time calculation.

Perimeter

In the dashboard, we use the same HOTD definition as Z1T_HAULIER which considers that if there is no real arrival date then the shipment is not included in the calculation. We only consider the orders that have a real delivery date (= the haulier enters in the system the achieved delivery date).

Page tree

SCE Dashboard - HOTD

Reference date:

KPI:

Comments: