1. User Guide
  2. Overview of ALM BI Dashboards and Reports
  3. ALM Report Details
  4. Liquidity Gap Detail - Product in Consolidated Currency

8.7.38 Liquidity Gap Detail - Product in Consolidated Currency

Table 8-24 Liquidity Gap Detail - Product in Consolidated Currency

Report Name(s) Liquidity Gap Detail - Product in Base Currency Liquidity Gap Detail - Product in Consolidated Currency
Description The report displays the Gap Amount by Product across liquidity time buckets.
Dashboards Prompts

Prompt Liquidity Gap 01

  • Process
  • Scenario

Prompt Liquidity Gap 02

  • As of Date
  • Currency
  • Result Type

Prompt Liquidity Gap 03 Product

  • Dynamic Gap Date

Prompt - Bucket End Date

  • Bucket End Date
Report Criteria

"Time Buckets"."Start Date"

"Time Buckets"."End Date"

"Time Buckets"."Bucket Name"

Case when Product."Account Type" in (100,110, 200) then 'Total Inflows' when Product."Account Type" in (800) and "Liquidity Risk Gap"."Leg Type"=2 then 'Total Inflows' when Product."Account Type" in (300,310, 400) then 'Total Outflows' when Product."Account Type" in (800) and "Liquidity Risk Gap"."Leg Type"=1 then 'Total Outflows' end

Product."Product Name Level18"

"Currency"."Base Currency"

ifnull("Liquidity Risk Gap"."LR Gap Principal Runoff

(1661)"+"Liquidity Risk Gap"."LR Interest CF Net (1672)",0)
Conditions "Product"."Account Type" IN (100, 110, 300, 310, 800, 200, 400),BOTTOMN("Time Buckets"."End Date",12) <= 12
Compound Layout

Title

Pivot Table