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

What the new KSA matrix did

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). KSA moved to a new MatrixVersion when its fiscal year started in April 2026. How much higher is the KSA collective allowance at the latest month end in the data (30 September 2026) under the version in force than under "Policy FY2025" (same scenarios), in SAR?
Expected
One amount in SAR, 2 decimals · KPI card
Tables
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +1 · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • FactLossRates
  • FactMacroScenarios
  • OpenAmount
  • LossRatePct
  • MatrixVersion
  • EffectiveFrom
  • Weight
  • Multiplier

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