Settings
×
Appearance
Light
Dark
Language
English
Deutsch
Text size
Small
Medium
Large

Good morning, Sara

Here's your April update

View as
This morning

11 items need attention

Urgent3
High3
Medium5
Cleared5
⋮
New cases opened
47
→ 2 same as last week
⋮
Cases at risk
3
↑ 2 vs yesterday
⋮
Avg resolution time
3.2 days
↑ 0.2 vs last week
⋮
Cases delayed this week
30
↑ 0.2 vs last week
Down 18% over the last month
Cases at risk
↓ 18% vs last month ⋮
View in performance →
Type of
Issues
⋮
Customs
18
Vessel
12
Supplier
5
Documentation
32
Ports
32
View in performance →
OTIF this month
94.3%
↑ 2% Above target
⋮
View in performance →
Cases
2000 cases · 10 alerts · 9 opportunities
Cases
SKUs
Containers
⌘K
14 at risk 12 tasks upcoming
CASE-001ShipmentTask upcoming
• On track
Acme Corp
2 Shipments 12 Containers
CASE-002ShipmentTask upcoming
• Delayed
Acme Corp
2 Shipments 12 Containers
CASE-003ShipmentTask upcoming
• Due Next Week
Acme Corp
2 Shipments 12 Containers
CASE-004ShipmentTask upcoming
• Open
Acme Corp
2 Shipments 12 Containers
1 2 3 … 8 9 10
Shipment ID Status Route ETA Mode Activity Active cases
SH-001
 Active Yantian → Long Beach May 18 1
CASE-001
SH-002
 Active Yantian → Long Beach May 18 4
CASE-002
SH-003
 Active Yantian → Long Beach May 18 1
CASE-001
SH-004
 Active Yantian → Long Beach May 18 4
CASE-002
SH-005
 Active Yantian → Long Beach May 18 1
CASE-001
SH-006
 Active Yantian → Long Beach May 18 4
CASE-002
SH-007
 Active Yantian → Long Beach May 18 1
CASE-001
SH-008
 Active Yantian → Long Beach May 18 4
CASE-002
123 … 8910
Article Status Total qty In transit At customs Active cases
110920111
Frozen fish
 Active 24,000 units 600 600
CASE-001CASE-005+4
110920111
Frozen fish
 Active 24,000 units 600 600
CASE-001CASE-005+4
110920111
Frozen fish
 Active 24,000 units 600 0
NONE
110920111
Frozen fish
 Active 24,000 units 600 0
CASE-001CASE-005+4
110920111
Frozen fish
 Active 24,000 units 600 0
CASE-001CASE-005+4
110920111
Frozen fish
 Active 24,000 units 600 0
NONE
110920111
Frozen fish
 Active 24,000 units 600 0
CASE-001CASE-005+4
110920111
Frozen fish
 Active 24,000 units 600 0
CASE-001CASE-005+4
123 … 8910
← Case overview
Case workspace
CASE-001Shipment
Shanghai CN → Rotterdam NL
Acme Industries·ETA Apr 15·• Delayed
Work session
0 selected
Shipments summary
2 shipments · 10 activities · 2 opportunities
Control tower
3 shipments · 5 containers
Everything up to date
No alerts
Shipments
Orders
1 order · 8,450 units
Control tower
Active alerts on this phase
3 of 9 shown
i
Supplier confirmed PO-1001 — 2,850 units
Confirmation received from Wuhan Foods 48 min ago. Booking window opens Apr 24.
View →
!
Supplier short-ships PO-1001 by 400 units
Werbetermin at risk — HU RDC running at 1.8 wk Reichweite. Bestellstopp recommended.
Take action →
⚠
PO-1001 missing commercial invoice
Document required for customs release. Supplier email auto-drafted — awaiting send.
Review →
Show 6 more alerts →
PO-1001
Confirmed
Supplier
Wuhan Foods Ltd
Incoterm
FOB Shanghai
Total value
$142,500
Units
8,450
Cargo Ready Date
Apr 28, 2026
Destination
NL-HEE IDC
Quotes
2 quotes · no pending activities · 2 opportunities
Control tower
3 quotes
Everything up to date
No alerts
Quote details
Truck · LA to Seattle
Freight Ways
$2,400
Accepted
Quote ID
QT-100
Valid until
26 May, 2026
Truck · LA to Seattle
Freight Ways
$2,400
Accepted
Quote ID
QT-101
Valid until
26 May, 2026
Bookings
2 bookings · no pending activities · 2 opportunities
Control tower
3 bookings
Everything up to date
No alerts
Booking details
Financials
3 invoices · 10 activities · 2 opportunities
Control tower
3 invoices · 5 containers
Everything up to date
No alerts
Financial details
Ocean Freight — Shanghai to LA
Invoice
Maersk Line
$10,340
Pending
Invoice ID
INV-2026-0118
Due date
26 May, 2026
IDC Handling — NL-HEE Heerlen
Invoice
Heerlen Logistics
$4,210
Approved
Invoice ID
INV-2026-0119
Due date
26 May, 2026
Inland Haulage — Heerlen → RDC NL-HEE
Invoice
Inland Haulage Europe GmbH
€2,830
Approved
Invoice ID
INV-2026-0120
Due date
26 May, 2026
Home›Inventory

Overview

11,937 articles · 167,711,370 pieces · 4 countries
Capital locked
€308M
↑ €12M vs last month
Dead stock value
€6.8M
8 articles
Active alerts
23
5 overdue
Savings available
€240K
5 opportunities
Countries
Healthy
Watch
Overstock
Critical
Extreme
Dead
Understock
Hungary
3,572 articles
8 alerts
Stock value
€128M
Avg range
−7.7 yrs
Daily outflow
66,138
Capital locked€103.4M
Open →
Netherlands
4,051 articles
4 alerts
Stock value
€113.9M
Avg range
−4.4 yrs
Daily outflow
83,675
Capital locked€97.5M
Open →
Finland
2,941 articles
3 alerts
Stock value
€90.3M
Avg range
−5.5 yrs
Daily outflow
53,597
Capital locked€75.5M
Open →
Slovenia
1,373 articles
On target
Stock value
€42.1M
Avg range
−3.2 yrs
Daily outflow
28,420
Capital locked€31.6M
Open →
Home›Inventory

Opportunities

11,937 articles · 167,711,370 pieces · 4 countries
Transfers
Dead stock
Stop orders
Understock
Transfer opportunities
Move overstock from one warehouse to one in need — savings is freight + capital unlock.
€240K savings available
Article
IAN
From
To
Quantity
Savings
Tricolore Fürst Pückler
10854983
HU·SFV 122.6w
→ NL·ECS 7.4w
30,383 pcs
€106K
Eisschale Kakao
10871348
NL·WEE 151w
→ HU·ECS 4.1w
17,168 pcs
€60K
Saté Huhn ohne Stiel BL
10808813
HU·SFV 55w
→ NL·OOS 2.6w
8,119 pcs
€28K
Backofen Pommes Frites 7×7
10970610
HU·HEJ 29.2w
→ FI·JAN 7.5w
7,422 pcs
€26K
Kartoffelspalten Potatoe Wedges
10888012
FI·JAR 78.2w
→ FI·ARJ 3.7w
5,603 pcs
€20K
Home›Inventory

Forecast

11,937 articles · 30-day stock projection · inbound shipments from Cases + weekly Lidl sales patterns
CountryAll
CategoryAll
Horizon30 days
Hungary
RDC 11 HU-ECS · Frozen TiKo · 3,572 active SKUs
May 1 – May 30, 2026
→ Holding · still overstocked
Current stock
384,000 u
Daily outflow
9,440 u/d
Reichweite
5.8 wk
Next arrival
May 1 · SHP-501
Stock (units)
28d target · 264,000
SHP-501 · +3,200
SHP-101 · +2,140
May 1May 8May 15May 22May 30
Above target
Below target
Critical
28d target
Daily sales (Lidl weekly pattern)
Shipment arrival
Incoming arrivals (from Cases)2 scheduled
May 1
SHP-501CASE-005Chicken Nuggets · SKU-TK-7711 · historical delivery
+3,200 u · +0.0 wk
May 9
SHP-101CASE-002Eisschale Kakao · IAN 10871348 · inter-company transfer in
+2,140 u · +0.0 wk
Projected Reichweite at May 30: 40.7 wk (still overstocked — transfer out advised)
AI · Transfer 3,200 u of SKU-TK-7711 to FI-JAN · frees €16K
Netherlands
NL-HEE IDC · mixed TiKo + BakeOff + NonFood 2501 · 4,051 SKUs
May 1 – May 30, 2026
↑ Recovering
Current stock
198,000 u
Daily outflow
11,950 u/d
Reichweite
2.4 wk
Next arrival
May 4 · SHP-001
Stock (units)
28d target · 334,600
SHP-001 · +2,450
SHP-301 · +8,100
SHP-302 · +7,900
SHP-303 · +7,600
SHP-002 · +4,100
May 1May 8May 15May 22May 30
Above target
Below target
Critical
28d target
Daily sales (Lidl weekly pattern)
Shipment arrival
Incoming arrivals (from Cases)5 scheduled
May 4
SHP-001CASE-001MSCU1234569 customs cleared · partial · TiKo variety
+2,450 u · +0.0 wk
May 8
SHP-301CASE-003Garden furniture · 3 FCL Haiphong→Hamburg→HEE
+8,100 u · +0.1 wk
May 12
SHP-302CASE-003Garden furniture · 2nd batch
+7,900 u · +0.1 wk
May 15
SHP-303CASE-003Garden furniture · 3rd batch
+7,600 u · +0.1 wk
May 18
SHP-002CASE-001Ningbo → Rotterdam · NonFood 2501 final leg
+4,100 u · +0.0 wk
Projected Reichweite at May 30: 3.1 wk · within target band
AI · 5 inbound shipments converge · space allocation auto-planned
Finland
FI-JAN + FI-JAR + FI-LAU · Frozen TiKo · 2,941 SKUs
May 1 – May 30, 2026
▼ Worsening
Current stock
141,000 u
Daily outflow
7,650 u/d
Reichweite
2.6 wk
Next arrival
—
Stock (units)
28d target · 214,200
May 1May 8May 15May 22May 30
Above target
Below target
Critical
28d target
Daily sales (Lidl weekly pattern)
Shipment arrival
Incoming arrivals (from Cases)0 scheduled
No inbound shipments scheduled in this window — see Cases to plan replenishment.
Projected Reichweite at May 30: 0.8 wk · stockout risk on SKU-TK-7711, SKU-TK-9200
AI · No inbound scheduled · recommend 3,200 u transfer from HU-ECS
Slovenia
SI-ARJ RDC 5 · TiKo + BakeOff · 1,373 SKUs
May 1 – May 30, 2026
→ Holding
Current stock
82,000 u
Daily outflow
4,060 u/d
Reichweite
2.9 wk
Next arrival
May 1 · SHP-401
Stock (units)
28d target · 113,680
SHP-401 · +2,100
May 1May 8May 15May 22May 30
Above target
Below target
Critical
28d target
Daily sales (Lidl weekly pattern)
Shipment arrival
Incoming arrivals (from Cases)1 scheduled
May 1
SHP-401CASE-004BakeOff Laugenbrezel · Bäckerei Otto · road delivery
+2,100 u · +0.1 wk
Projected Reichweite at May 30: 2.4 wk · tight · SHP-002 lands Jun 14 (out of window)
AI · Monitor closely · reorder trigger at SKU-BO-1240 in 8 days
Home›Inventory

Commitments

11,937 articles · 167,711,370 pieces · 4 countries
Purchase commitment pool
Annual fixed requirement minus actual orders placed. Alerts trigger at below 20% remaining.
Country
Annual req.
Ordered
Remaining
%
Progress
Status
Hungary
450,000
391,500
58,500
13%
Critical
View orders →
Finland
380,000
281,200
98,800
26%
Watch
View orders →
Netherlands
520,000
317,200
202,800
39%
Watch
View orders →
Slovenia
290,000
139,200
150,800
52%
On track
View orders →
Shipment linkage coming soon — commitments will be traceable to individual booking and shipment records.
Home›Inventory

History

11,937 articles · 167,711,370 pieces · 4 countries
Anomaly detection
July – October 2025
Inventory increasing while sales fell 40%
Hungary + Finland · Aug–Sep 2025 · Likely cause: promotion cancellation not reflected in planning
Investigate →
Purchase quantity does not match order quantity (−18% gap)
All countries · Jul 2025 · Likely cause: supplier partial delivery not flagged in system
Investigate →
Zero outbound picks for 3 consecutive weeks
Netherlands · Sep 2025 · Likely cause: possible assortment delisting not updated in system
Investigate →
Daily outflow dropped 35% with no corresponding demand change
Finland · Oct 2025 · Likely cause: warehouse operational issue
Investigate →
Data quality
Gaps identified in article master data
Article family coverage: 68% of articles unclassified
System applied rule-based imputation based on category. Human review recommended before using for segmentation analysis.
Review →
BBD remaining terms missing on 12% of articles
Affects dead stock calculations for perishable items. Manual update required.
Review →
Inventory/Hungary

Hungary · inventory

4 RDCs · 3,572 active SKUs
Warehouses
Click a warehouse to drill into SKU groups
Inventory/Hungary/HU-ECS

HU-ECS · RDC 11

156 active SKUs · 68,420 units
SKU groups
Article families by UWG · click to open drill-down
SKU
Article
Units
Reichweite
Kapital €
Days on hand
Status
Action
Activities
51 active alerts · 3 tasks overdue
View all
Active
Archived
⌘K
Vessel rollover detected MSCU1290111 Shipment
Global Electronics · CASE-001 · Documentation · 3h ago
Documentation review required
Due: 27 Mar

Meta  Due: 27 Mar
L2 — Korrektur
View container
Vessel rollover detected MSCU1290111 Shipment
Global Electronics · CASE-002 · Documentation · 3h ago
Auto-completed
System sent departure notice to Acme Industries at 09:41
L2 — Korrektur
View container
Early warning: late ETD risk MSCU1290111 Shipment
Global Electronics · CASE-002 · Prävention · 3h ago
Auto-completed
System sent departure notice to Acme Industries at 09:41
L1 — Prävention
View container
Customs delay: container MSCU1290111 on hold Shipment
Global Electronics · CASE-003 · Customs · 5h ago
L3 — Qualität
View container
Port congestion alert — pre-arrival notice Shipment
Acme Industries · CASE-001 · Prävention · 6h ago
L1 — Prävention
View container
Container rollover detected — rebook required Shipment
Global Electronics · CASE-004 · Vessel · 8h ago
L2 — Korrektur
View container

Performance

OTIF · 12-week rolling window · 388 shipments tracked · 6 carriers · 12 lanes
OTIF
89.2%
↑ 1.8 pts vs last 12w
On-time
91.4%
↑ 0.9 pts
In-full
97.8%
• flat
Transit
23.4 d
↓ 0.8 d
D&D exposure
€148K
↑ €22K YTD
D&D avoided
€238K
↑ €34K via AI
Shipments
388
• on plan
Active lanes
12
+1 (Rotterdam)
OTIF trend
Weekly OTIF % across all carriers and lanes
Historisierung — Lieferperformance
OTIF % week-over-week · Lieferwoche KW1–KW17 2026
Target: 95%
KW-Avg OTIF
89.2%
↑ 1.8 pts vs KW1–5
Best week
KW12 · 94.1%
Peak performance
Worst week
KW3 · 81.4%
Port strike impact
Below target
5 / 17 weeks
• KW1–3, KW7, KW11
OTIF by carrier · lane costs
Volume-weighted · Σ shipments = 412 across 12 weeks
CarrierShipsOTIFOT%IF%Avg / tgtD&DTrend
Maersk Line
Trans-Pacific, Asia→EU · 3 lanes
 142
91%
 94% 97% 23.1d / 24 €42K ↑ 2.1
MSC
Asia→EU · 4 lanes
 98
87%
 90% 97% 24.8d / 24 €31K ↑ 0.4
CMA CGM
Asia→EU · 2 lanes
 76
89%
 92% 97% 23.5d / 23 €28K ↑ 1.2
Hapag-Lloyd
Asia→EU via Suez · 2 lanes
 54
82%
 85% 96% 25.2d / 24 €24K ↓ 3.1
COSCO
Trans-Pacific · 1 lane
 42
76%
 79% 96% 26.1d / 24 €23K ↓ 4.8
Lidl milestone punctuality
On-time % per UC2 contractual milestone · CHARGE 2501
SR
1
Shipment Release
Target: 14 wks before LT Land (96 d)
96%
↑ 1.2
CRD
2
Cargo Ready Date
Target: 12 wks before LT Land (82 d)
84%
↓ 3.4
ETD
3
Planned ETD
BOOK_ETD_DT
92%
↑ 0.5
ATD
4
Actual Time of Departure
TRANS_ATD
89%
↓ 0.8
ETA
5
Estimated Time of Arrival
Target: 6 wks before WT (42 d)
87%
↓ 1.1
ATA
6
Actual Time of Arrival
Target: 6 wks before WT (42 d)
81%
↓ 2.8
PICK
7
Pickup at POD
PICKUP_POD_DT
86%
↓ 0.4
ADT
8
Arrival Domestic Terminal
ARRIVAL_DOMESTIC_TERMINAL_DT
83%
↓ 1.6
GAS
9
Gas Clearance
Target: 30 d before WT
78%
↓ 2.9
CUS
10
Customs Clearance
Target: 29 d before WT
79%
↓ 3.2
GR-IDC
11
Warehouse Inbound IDC
Target: 3 wks before WT (21 d)
88%
↑ 1.4
GR-RDC
12
Warehouse Inbound RDC
Target: 1 wk before WT (7 d)
91%
↑ 0.8
OTIF by lane
Top 6 by volume · includes primary bottleneck milestone
LaneShipsOTIFSlipPrimary bottleneck€/FEU
Shanghai → Rotterdam
Maersk · MSC · CMA CGM
 112 91% +0.5 d Customs €2,410
Ningbo → Rotterdam
MSC · CMA CGM
 84 88% +1.2 d Port pickup LA €2,380
Shanghai → LA → RTM
Maersk · COSCO
 64 78% +3.8 d IDC handling €3,120
Haiphong → Hamburg
Hapag-Lloyd · CMA CGM
 42 72% +5.1 d CRD slip €2,840
Qingdao → Hamburg
Maersk · MSC
 38 89% +0.8 d Gas Clearance €2,190
Kaohsiung → Rotterdam
CMA CGM
 24 94% −0.2 d None €2,520
What's causing delays
Ranked by % share of total slippage · 12w
1
Destination customs clearance
LA Port + Hamburg backlog driven by 2024 CBP audit requirements. Documentation completeness is single biggest lever.
46 / 388Shipments affected
+2.1 dAvg slip
28%Share of delays
↓ worseTrend
€87K
YTD exposure
2
Gas Clearance Measurement
Phytosanitary inspection queue at NL-HEE IDC. Slots are booked 4 days out, so any GR-IDC slip cascades to WT.
38 / 388Shipments affected
+1.5 dAvg slip
22%Share of delays
↓ worseTrend
€34K
YTD exposure
3
Cargo Ready Date slip (supplier)
Garden furniture lots (Dongguan Outdoor) slipping CRD target by avg 3.8 d — supplier capacity constraint.
22 / 388Shipments affected
+3.8 dAvg slip
16%Share of delays
→ flatTrend
€42K
YTD exposure
4
Port pickup at POD
LA Port Terminal 3 congestion. Shipments waiting avg 2.4 d for pickup after discharge.
31 / 388Shipments affected
+2.4 dAvg slip
14%Share of delays
↑ betterTrend
€28K
YTD exposure
5
Vessel re-routing (Red Sea)
Houthi disruption forcing Cape route on some Hapag-Lloyd sailings · +5 days.
14 / 388Shipments affected
+5.1 dAvg slip
10%Share of delays
↑ betterTrend
€24K
YTD exposure
Cost breakdown · YTD 2026
€3,438K total spend · freight + accessorial
€3.44M
YTD
Ocean freight €2,800K 81.4%
Inland haulage €428K 12.4%
Demurrage €86K 2.5%
Customs fees €34K 1.0%
Broker / expedite €28K 0.8%
Detention €62K 1.8%
Orkestra AI · D&D avoided YTD
47 interventions · avg €5,063 per save · driven by customs/docs auto-draft
€238K
Recent delays · watchlist
Shipments that missed or are about to miss a milestone
SHP-001 · MSCU1234569 at customs
LA Port · held 3d 7h · DEST_CUSTOMS_CLEARANCE_DT · Maersk Line
+3 d
~€4,140 exposure · AI mitigating
SHP-301 · Red Sea re-route
Hapag-Lloyd · Haiphong → Hamburg · Werbetermin CW20 at risk
+5 d
~€8,200 exposure · Garden CW20
SHP-302 · Suez approach queue
Hapag-Lloyd · 12 nm from Suez · slow-steaming
+2 d
No Werbetermin impact
PO-1001 CRD slip
Wuhan Foods · CRD target 2026-02-01 · actual 2026-02-05
+3 d
Downstream ETD held
CRD slip · Garden lots
Dongguan Outdoor · CASE-003 · 4 lots trailing supplier capacity
+3.8 d
~€12K carrying cost
SHP-401 gate-in late
Stuttgart → SI-ARJ · caught up in transit · no WT impact
+4 h
Resolved
GR-IDC NL-HEE slot shift
Queue moved by 1 slot · phytosanitary rescheduled
+6 h
Within tolerance

Data Quality

UC1 (TiKo + BakeOff) and UC2 (Ausmusterung 2501) source tables · audit from documented gotchas
Overall score
87%
Weighted by KPI coverage
Tables audited
14 / 14
UC1: 13 · UC2: 1 consolidated view
Sparse columns
6
All documented, none block KPIs
AI + enriched
+605
Articles recovered via EKS LTRIM
Structural anomalies
6
5 handled · 1 in-progress
Source table health
Traffic light per documented quality (xlsx Tabellenblatt1) with load-time actions applied
Clean
Known gaps
Documented partial
Table
Rows
Status
Notes
Article_Masterdata
UC1 · Master
8,148
Conversion factors (KARTON_LAGE, KARTON_DUESS) incomplete. FAMILY_ID ~32% coverage (Workshop Task H). EKS_NUMMER ~33.4% → 40.8% after LTRIM(ARTNRVIER, '0') rule from Data Model PDF p.3. TRANSPORTWEG_* ~30%.
Enriched
Article_Masterdata_EKS_Add_on
UC1 · Master
2,719
Purchasing enrichment (supplier, production site, transport route). Used to recover +605 articles where LTRIM(ARTNRVIER, '0') == EKS_NUMMER.
Loaded
RDC_Client_WH_Masterdata
UC1 · Master
—
Covers all Lidl countries (includes AT). UC1 scope filter applied: CLIENT_ID IN (11, 16, 22, 28).
Scope filter
Inbound Transport · European Land Freight
UC1 · Supply
—
Transport milestones supplier → cross-dock → RDC. Joined to RDC_Inbound via WAWIPURCHASEORDERID = PO_NR.
Loaded
RDC_Inbound
UC1 · Supply
83,511
17,421 rows (20.86%) are manual HU goods-receipt corrections — null ARTIKELNR, WH_NR, PO_NR, CLIENT_ID. WEKORRDATUM populated on 99.9%. Confirmed by Niklas (Apr 23) — exclude from article/warehouse KPIs.
Excluded 17,421
RDC_Inbound_Add_on
UC1 · Supply
—
Supplies MENGE (order qty) and LIEFDATUM where missing in RDC_Inbound.
Loaded
RDC_Stock
UC1 · Stock
—
DATUM in German format DD.MM.YYYY — converted to ISO on load (only UC1 column with this quirk).
Date converted
RDC_Stock_missing_items
UC1 · Stock
—
Out-of-stock events. Rows dropped where timestamp order is inconsistent across MISSING_FROM → MISSING_UNTIL → EST_RCV_DATE.
Row filter
RDC_Outbound_Picking
UC1 · Outbound
—
POSITION_NR = 9999999 are pallet-summary rows (359,564 of them) — must be filtered on any picking-level analysis. VPLP/VPLK presence inconsistent.
Pallet rows out
RDC_Outbound_ReportedTour
UC1 · Outbound
—
Tours not always closed. TOUR_STATUS sometimes in national language. TIKO flag not always set correctly by disposition.
Loaded
RDC_Outbound_ReportedAddressState
UC1 · Outbound · 324,484 rows
324,484
Per-stop telematics (arrival / departure at each store on a tour). Flagged red by Lidl's own table-quality scale (Table_Documentation_Use_Case_1.xlsx row 128). Per that note: "Rollout of the function started in October 2025 and we only receive data if the truck visits the stores in the planned order." Empirically ~98% of telematics actuals are null in the UC1 window (Jul–Oct 2025). Any "actual arrival at store" KPI is computable only on the populated ~2% subset — we scope those KPIs to that subset and surface a coverage footnote in the dashboard.
~98% null
Store_sales_aggregated_to_RDC_level
UC1 · Demand
—
Not pre-filtered to UWG 20 (TiKo) and 74 (BakeOff) — filter applied at load. UTF-8 BOM on col 1, COUNTRY_CODE lowercase → normalized, C520_DATE has TZ offset → loaded as timestamptz.
Scope filter
Prognose-Horizont (5 sheets)
UC1 · Demand
—
Multi-sheet xlsx (Jul–Nov 2025), merged Gesamtübersicht headers. Gesamt subtotal rows removed; RS (Serbia) filtered out — UC1 scope is FI/HU/NL/SI only. Unpivoted into long format prognose_horizont(country, ian, nan, month_dt, metric, value_pal).
Unpivoted
Dataset_2_Seafreight_IDC_RDC-WE
UC2 · E2E
41,023
Pre-joined E2E view (48 cols). ID_IAN_COUNTRY_CHARGE flagged PK but NOT unique at row level. Physical PK is 5-tuple (LOT_NR, IAN_NR, TARGET_COUNTRY, CONTAINER_NR, CHARGE) → 41,020 distinct rows. 3 residual dupes on Lot 487597-KOP-1 (GAS_MSMT_RESULT_NAME 'none' vs '') — deduped by keeping populated value.
3 dupes resolved
Article_Masterdata — known-sparse columns
Coverage % per column · sourced from Table_Documentation_Use_Case_1.xlsx + empirical audit
FAMILY_ID / FAMILY_DESC
32%
Workshop Task H asks vendors to rule-base / AI-fill — treat as enrichment step, not a load failure.
EKS_NUMMER
40.8%
33.4% native → 40.8% after LTRIM(ARTNRVIER, '0') rule from Data Model PDF p.3 (+605 articles).
TRANSPORTWEG_KURZ / LANG
30%
Co-varies with EKS_NUMMER — same matching path via EKS Add_on "ordered transport route" fields.
WEITERLEITUNGSNR
~10%
Documented as "mostly empty (what's wrong)" in xlsx row 2. Not required for core KPIs.
INT_ITEMNR (IAN)
Partial
Flagged as PK in docs but coverage acknowledged as partial — NOT NULL not enforced at load.
KARTON_LAGE / KARTON_DUESS
Partial
Fall back to ARTGRUPNR defaults or derive from INHALT_KARTON × KARTON_EURO where possible.
Structural anomalies
Documented issues from UC1 §11a + UC2 §10a — each has a source citation
HU manual GR corrections — 17,421 rows (20.86%) of RDC_InboundUC1Confirmed Apr 23
Null ARTIKELNR, WH_NR, PO_NR, CLIENT_ID. WEKORRDATUM populated on 99.9%. 99.67% carry LANDKZL='HU'. 5.9% WE_ID overlap with normal rows → double-count risk. Excluded from article/warehouse inventory KPIs.
Table_Documentation_Use_Case_1.xlsx row 60 · UC1 Handout p.1 §2
Open →
RDC_Outbound_Picking — 359,564 pallet-summary rows must be filteredUC1
POSITION_NR = 9999999 shows pallet numbers and types (not actual picks). Documented in Table_Documentation xlsx. Must apply WHERE POSITION_NR <> 9999999 on any picking-level analysis (picks per tour, pick efficiency, lines per SKU).
Table_Documentation_Use_Case_1.xlsx — POSITION_NR column note
Open →
ReportedAddressState ~98% empty — expected (Oct 2025 rollout)UC1
Per-stop telematics data only arrives when trucks visit stores in planned order. Any "actual arrival at store" KPI is computable only for the populated subset. Document coverage footnote on dashboards; don't treat empties as a load problem.
Table_Documentation_Use_Case_1.xlsx — red traffic light
Open →
UC2 row-grain — ID_IAN_COUNTRY_CHARGE is NOT unique at row levelUC2
xlsx PK flag conflicts with Handout p.10 reporting grain (Lot + IAN + Country) and p.9 example (5 rows per Lot across Countries/Containers). Physical PK resolved as 5-tuple (LOT_NR, IAN_NR, TARGET_COUNTRY, CONTAINER_NR, CHARGE).
UC2 Handout pp. 9–10 · Data Model PDF §10
Open →
UC2 quantity fields are grain-sensitive — do not SUM across container rowsUC2
BOOKED_CTN_LOT = Lot grain (use MAX/DISTINCT). TOTAL_SHIP_PROD_QTY = Lot+Country+Container (SUM OK). VMT_SHIP_PROD_QTY_IAN_COUNTRY_CHARGE_GROUP and ZLX002_DELIVERY_QTY_IAN_COUNTRY_CHARGE_GROUP = Lot+Country (pre-aggregated, do not re-SUM).
UC2 Handout p.9 example · Lot 463316-RTM-7
Open →
Prognose-Horizont — multi-sheet pivot, Gesamt + RS rows filteredUC1
Delivered as 5 sheets (Juli–Nov 2025) with merged Gesamtübersicht titles. Gesamt subtotal rows (row 7) dropped to avoid double-counting. Country = 'RS' (Serbia) filtered — outside UC1 scope (FI/HU/NL/SI only).
UseCase1_DataModel.md §11a.3
Open →
Load-time normalizations applied
Transforms the ingest pipeline runs so downstream queries don't re-solve these
RDC_Stock.DATUM
German DD.MM.YYYY → ISO on ingest
WH_NR / WH_ID
Cast to smallint (zero-padded strings vs int mixed across tables)
Store_sales.COUNTRY_CODE
Lowercase → uppercase, UTF-8 BOM stripped
Store_sales — scope filter
WHERE C520_ITEMGROUP IN (20, 74) — TiKo + BakeOff only
RDC_Client_WH_Masterdata
CLIENT_ID IN (11, 16, 22, 28) — UC1 scope
UC2 column rename
WT CALC → wt_calc · BOOK_ETD_DT (...) → book_etd_dt · DEST_WH_NAME COUNTRY → dest_wh_name_country
Article_Masterdata enrichment
LTRIM(ARTNRVIER, '0') lookup in EKS_Add_on → +605 articles
UC2 Today convention
Today = MAX(actual dates in file) — reproducible R/Y/G across re-opens
Select an alert from the queue
Invoice
—
Download
×