Skip to main content
DD-ECL-002-Q034 Medium Time series

Group allowance movement

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. By how much did the group's total allowance change from 31 December 2025 to the latest month end in the data (30 September 2026), in AED?
Expected
One amount in AED, 2 decimals · KPI card
Tables
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +2 · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • FactLossRates
  • FactMacroScenarios
  • DimEntity
  • OpenAmount
  • 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