The riskiest segment in the group
Append FactOpenItemsLatest to FactOpenItems first. Days past due (DPD) = the SnapshotDate minus the DueDate in days. Buckets: Current (DPD 0 or less), 1-30, 31-60, 61-90, 91-180, 180+ (over 180). The allowance policy at a month end: a customer whose CreditImpairedDate is on or before it is provided at OpenAmount x (100 - ExpectedRecoveryPct)% - the specific allowance. Every other open item: OpenAmount x LossRatePct% x FLI - the collective allowance - where LossRatePct comes from its entity's MatrixVersion in force (latest EffectiveFrom on or before the date) for the customer's Segment and the item's Bucket, and FLI is the forward-looking factor of the customer's Segment: the sum of Weight x Multiplier over the scenarios of its entity's ScenarioSet in force (latest ValidFrom on or before the date). Group amounts are in AED: multiply KSA amounts by its RateToAED in DimEntity. Which Segment has the highest coverage (allowance / receivables, both in AED) across the group at the latest month end in the data (30 September 2026)?
- Expected
- One Segment · KPI card
- Tables
-
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +2 · columns