Skip to main content
DD-ECL-002-Q024 Medium

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
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • FactLossRates
  • FactMacroScenarios
  • DimEntity
  • OpenAmount
  • Segment
  • LossRatePct
  • Weight
  • Multiplier
  • RateToAED

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us