1. User Guide
  2. Overview of ALM BI Dashboards and Reports
  3. ALM Report Details
  4. Distribution Profile of Term Deposits

8.7.40 Distribution Profile of Term Deposits

Table 8-26 Distribution Profile of Term Deposits

Report Name(s) Distribution Profile of Term Deposits
Description The report displays the balance of Term Deposit funding across Organization Unit.
Dashboards Prompts

Prompt - Distribution Profile of Term Deposits

  • As of Date
  • Currency

Prompt for Term Deposits

  • Product Name
Report Criteria

Remaining Term Bucket."Bucket Name" Organizational Unit."Org Unit Name Level16"

Organizational Unit."Org Unit Leaf Name"

ifnull("Account Summary"."Cur Net Book Bal C"/1000000,0)

"Currency"."Base Currency"

Liquidity Risk Gap."Net Liquidity Gap"
Conditions

"Account Summary"."Remaining Term Bucket Number Char" IN ('1', '2', '3', '4', '5', '6', '7', '8')

and UPPER("Instrument Type"."Instrument Type") = 'TERM DEPOSITS' and Mls Cd is equal to / is in US
Compound Layout

Title

Pivot Table

Pivot Table 2

Pivot Table 3