BMS High Level View Dashboard
–
KPI Trends and Targets
PPSNC30 Trend vs. Target actual (solid) vs. weighted target (dashed)
Volume Trend unique SN in the PPSNC denominator
Field OLA 2BD Trend vs. Target actual (solid) vs. 85% FY26 target (dashed)
E2E 5BD TAT Trend vs. Target actual (solid) vs. 85% FY26 target (dashed)
RR30 Trend vs. Target actual (solid) vs. weighted target (dashed)
Field OLA 3BD Trend vs. Target
E2E 10BD TAT Trend vs. Target
Click a bar or month to filter. Insight follows the selected scope; default is overall.
Top 5 RCA Contributor by interventions
Top 5 Customer Contributor by unique SN
Top 5 Product Model Units eligible period-SN
Insight
Deep Dive
3Who Contributes?Customer Analysis Summary
4What Should We Do?Summary Analysis, Evidence And Actions
Service & Quality Breakdown
Service Level Analysis - Carepack
View details →
Field OLA 2BD Trend vs. 85% Target
Field OLA 2BD Miss Driver
E2E 5BD TAT Trend vs. 85% Target
E2E 5BD TAT Miss Driver
Service Level Analysis — Warranty
Field OLA 3BD Trend vs. 80% Target
Field OLA 3BD Miss Driver
E2E 10BD TAT Trend vs. 80% Target
Solid: actual · Dashed: target · Partial snapshot periods are marked. Click a point to filter its period.
PPSNC Analysis
PPSNC30 by Business Segment
Volume Share by Platform
Top Parts Consumed On in-Scope SN
RR30 (Rerepair) Analysis
View details →
RR30 Trend vs. Target
RCA RR30
RCA Analysis
View details →
RCA Pareto (Interventions + Cumulative %)
Top RCA by Platform
Top RCA by Customer
Customer Analysis
View details →
Volume by Customer (Unique SN)
PPSNC30 by Customer
Ranking
CopilotAsk your data
✦
Insight
computed automatically from the currently filtered data
KPI Trend And Measure
Measure
OLA-SIT Population
Latest Period
–
–
Overall Scope
–
–
PPSNC30
Volume (Unique SN)
Metric
Overall Target
Add 1 Digit
Top 10 Customers By Volume
Top 10 Customer by Volume (Unique SN)
Contribution Table
Contribution By
Supplier · vs. Targets
Market & Metrics Portfolio breakdown, KPI scorecard and Heat Map — consolidated single page
01 Market Portfolio Greater Asia › Indonesia (ID)
Market Portfolio
Each block breaks the Indonesia portfolio down by one business dimension.
Click a row to cross-filter the whole dashboard. Status uses the lower-is-better direction
(Actual ≤ Target = On Target).
02 KPI Scorecard vs. target, all KPIs
KPI Scorecard vs. Target
All KPIs are computed from the same filtered scope. Every KPI on this page is
lower-is-better. Δ vs. the previous period uses the granularity selected in the sidebar.
Trend by KPI
KPI × Period Matrix
03 Heat Map dimension × period
Heat Map
Operational Huddle
Every section below is built from the selected metric only — every figure is
computed directly from the filtered raw data, nothing is estimated. Lines with no available data are stated as such.
Huddle Priorities
What requires review, and who will follow up?
Data quality: KPI reconciliation requiredWork order conflicts and duplicate Case IDs remain unresolved.
Huddle Decisions · Corrective Action Plan
Suppliers update the latest status, action due dates and notes.
Follow-Up Drafts
Workflow preview · not yet an operational record
SIT & OLA Analysis — Field OLA 2BD and E2E 5BD TAT
–
Trend vs. Target one colour per metric; every marker is clickable and cross-filters the period
Field OLA 2BD Trend vs. 85% Target
E2E 5BD TAT Trend vs. 85% Target
Miss Driver every bar cross-filters the whole dashboard on that root cause
Field OLA 2BD Miss Driver
E2E 5BD TAT Miss Driver
Customer Mapping same master customer name on both fact tables — click a row to cross-filter
RCA Analysis every root cause behind Field OLA 2BD and E2E 5BD TAT misses — evidence-based, no estimate
Field OLA 2BD — RCA Pareto (Top 10, Cumulative %)
E2E 5BD TAT — RCA Pareto (Top 10, Cumulative %)
Rerepair Analysis — RCA RR30
–
RCA RR30 by Category official mapping — RR30_Miss_Reasons_Category, mutually exclusive, sums to 100%
RCA RR30 Components RR30_Miss_Reasons expanded on "|"
Multiple Miss Reasons — Combination Breakdown
Exact reason combinations behind the "Multiple Miss Reasons" category. Reasons are listed
alphabetically so the same combination is always reported under one label.
RR30 Trend vs. Target actual (solid) vs. volume-weighted target (dashed)
Miss reason category volume per period. The bottom two rows restate the RR30 numerator and the
RR30 rate of each period, so the matrix can be reconciled against the KPI directly.
Re-Repair by Dimension
Root Cause Behind The Re-Repairs
Mapping Reference Field Waste Metrics.pdf p.11-18
The documented condition for every RCA RR30. Reasons valid for EMEA Contractual MPS only
are listed for completeness and are expected to be 0 in the Indonesia scope.
Customer Analysis — Ranking, Concentration & KPI Profile
–
Customer Ranking vs. Target
Volume Concentration unique SN + cumulative %
Largest Volume Impact gap vs. target × denominator
Customers above their own target, ranked by how much volume sits above that target. This is the
list to work first: closing the gap on these accounts moves the country KPI the most.
Customer × Period Matrix
Customer Profile –
KPI Trend
Top Delay / RCA Codes
Product / Model Units
Service Partner Mix
RCA RR30
Top Parts Consumed On in-Scope Serial Numbers
City Mix (OLA-SIT Cases, Primary Contact City)
01 Supplier KPI Scorecard
Latest Complete Period · Click A Supplier To Filter
PPSNC30
–
Target: –
–
–
Partner Ranking vs. Target
Partner Trend — KPI by Fiscal Period
Partner × KPI Scorecard
Every KPI is evaluated against that partner's own volume-weighted target.
All four KPIs are lower-is-better. Click a row to cross-filter the whole dashboard by that partner.
Open Case Management Command Center
Command Center KPI sidebar and visual filters apply to the latest snapshot
✦
Insight
computed automatically from the currently filtered Open Case backlog — no target/trend invented, see Glossary
Management Attention Required computed over the currently filtered cases — see footnote for method
Top Critical Cases (>30 Days)
Aging Heatmap open case count, by CaseAgeBucket — top 8 Supplier / Customer by volume
By Supplier
By Customer
Top Root Cause (RCA) for Aging Cases (>10 Days)
by Anomaly (Row Grain)
Recommended Action qualitative guidance by Anomaly category — no numeric target invented
Distribution by Case Age case count, click a bar to filter this tab
Distribution case count — click a slice to filter this tab
by Segment
by Market (Commercial / Consumer)
by Business Type
Top Accounts & Suppliers distinct case count — click a bar to filter
by Service Account
by Supplier (Field Partner)
Anomaly row count (part-order-line grain) — see Glossary for the official OCM 2.0 definitions
Preventive Risk Trend
Trigger Distribution
Risk Driver Breakdown
Priority Accounts & Recommended Actions
Account profile & KPI drivers
Click an account in the queue or heatmap to view its profile and drivers.
Account Profile –
Account Health Trend
Controllable Delay
Parts Delay
Heatmap & prevention playbook
Prevention Heatmap
Controllable Delay Drivers
Parts Delay Drivers
Prevention Playbook
Open Case uses the latest snapshot, independently of KPI periods. Account and Supplier use the available shared scope. Account names are matched exactly.
Latest Status & Case Follow-Up
Power BI snapshot: 2026-10-15. Latest status is sourced from ISD; CAP requires action evidence. Queue and Supplier filters remain separate from KPI filters.
Select an account in the PAC table to view related snapshot cases, or search the Case Queue.
Early Warning
Backlog requiring review · snapshot status
Data quality: KPI reconciliation requiredWork order conflicts and duplicate Case IDs remain unresolved.
Backlog Review Queue
Sorted by case age · not an SLA breach forecast
| Case / Service Account | Age | Supplier | Latest Status / CAP | Follow-Up |
|---|
Anonymized Case Reference
Case Review & Action Drafts
Snapshot supplier · latest status and due date are entered during review.
Action Tracker
Local preview draft · not submitted or saved to an operational system
Raw Data
Master refresh · 30 October 2026. Material: 23,358 part rows; cutoff 2026-10-28. OLA/SIT: 15,727 eligible cases; cutoff 2026-10-28. Of the newly appended master rows, 12 Material RCA and at least one RCA on 385 OLA/SIT rows remain pending. Blank RCA is retained; recorded labels are not proof of a confirmed cause. RCA coverage is shown for each selected metric and scope. Open Case/ISD and backorder sources retain their separate existing cutoffs.
Warranty KPI Definitions
Field OLA 3BD and E2E 10BD TAT use eligible Warranty OTC 02N cases. Actual = sum of the respective source flag divided by the count of valid 0/1 flags. Blank flags are excluded. FY26 target: 80% for each metric. Field OLA cutoff: 3 PM; E2E TAT cutoff: 4 PM. Source headers: Field Ola 3Bd Flag and Sit 10Bd Flag. The current workbook contains metric-specific RCA columns, so flag and RCA lookup uses header names.
Carepack OLA 2BD and E2E 5BD TAT retain their separate OTC 05D/05K population and 85% target. Customer labels and existing KPI calculation inputs remain as supplied in the Desktop snapshot. Signed gap = actual minus target; rates use percentage points, while PPSNC uses parts/SN. Volume has no approved performance target.
KPI Definitions and Interpretation
| KPI | Population and Calculation | Target and Direction |
|---|---|---|
| PPSNC30 | Sum of PPSNC numerators from first-occurrence eligible interventions, divided by distinct eligible period-SN. | Applicable Indonesia segment and business-type target, weighted using the existing engine. Lower is better. |
| PPSND30 | Part rows on serial numbers in the eligible PPSNC population, divided by the same period-SN denominator. This retains the existing part-row proxy. | No configured target. Lower is better. |
| RR30 | Distinct first-occurrence interventions flagged for repeat repair, divided by distinct interventions in the RR30 scope. | Applicable Indonesia segment and business-type target. Lower is better. |
| 3+OS | Eligible RR30 interventions with the exact 3+OS token, divided by the RR30 intervention denominator. The existing calculation is retained; the newly available source flag is not substituted without approval. | User-approved country targets, weighted by eligible interventions. Lower is better. |
| Field OLA 2BD / E2E 5BD TAT | Sum of the corresponding valid 0/1 flag divided by valid flags in the Carepack population (OTC 05D/05K). | 85% for FY26. Higher is better. |
| Field OLA 3BD / E2E 10BD TAT | Sum of the corresponding valid 0/1 flag divided by valid flags in the Warranty population (OTC 02N). | 80% for FY26. Higher is better. |
Scope, Periods and Targets
Country: Indonesia. Material scope is inherited from the approved upstream extract. Service data is filtered to Indonesia, Onsite, Break_Fix, Commercial and Active Resource Blanks = 1, excluding DaaS/MPS in the source business classifications. Customer delays remain in the service KPI denominator. Blank service flags are excluded, not treated as misses.
FY26 runs from November 2025 to October 2026. Q1: November–January; Q2: February–April; Q3: May–July; Q4: August–October. Business-day thresholds are not calendar-day thresholds. Field OLA uses the 3 PM cutoff; E2E TAT uses the 4 PM cutoff.
Gap = actual minus target. Percentage gaps use percentage points; parts-per-SN gaps use ratio units. Performance status uses unrounded values. An actual equal to its target is compliant; the executive RAG icon marks equality in amber. N/A means no data or no configured target, not zero.
October 2026 is a partial snapshot. Headline comparisons retain the existing complete-period selection policy. Embedded trend target lines follow each period; target badges summarize the active scope. A verification date does not replace the source cutoff.
RCA and Recommended Actions
Repeat-repair analysis uses the recorded RCA RR30 field, not a renamed miss-reason taxonomy. Missing RCA remains in the denominator. Field OLA 2BD uses RCA OLA 2BD; other service metrics use their respective named RCA fields. Empty RCA fields do not justify invented causes or copied reasons from a different KPI.
Source categories are evidence-based drivers, not automatically confirmed root causes. Recommendations are proposed actions requiring case-level validation, assigned ownership and effectiveness checks. The dashboard currently uses local rule-based analysis. No connected generative AI service is configured.
Customer, Product and Location Views
Customer names follow the current workbook headers: Material CDAX Customer Name in column Q and OLA-SIT Customer Name in column AF. Source labels are retained. Product / model units use eligible period-SN. City counts use distinct source cases associated with the selected customer; they are not KPI denominators. Missing or conflicting locations are not guessed.
Open Case and Source Quality
Open Case uses only the latest available source snapshot. Case counts are distinct CaseID, work orders are distinct WorkOrderNumber, and anomaly counts are source rows. Case age and work-order age are calendar days unless explicitly labelled working days. Source ISD status is a workbook snapshot, not a live ISD query.
Material first-occurrence calculations are retained for parity. Source conflicts affect 15 numerator-flag interventions, 17 denominator-flag interventions and 52 RR30-scope interventions; these groups may overlap. Results remain provisional pending source-owner reconciliation. The refreshed eligible service population has no duplicate period–Case ID rows.
Interactions
Click a customer, supplier, product or period to filter the relevant dashboard scope. Ctrl/Shift-click allows multiple selections where supported. Segment buttons in KPI Evidence and RCA Analysis change the local analysis without changing the sidebar filters. City drill-down does not alter KPI calculations. Back to Top scrolls the dashboard to the top.
