18.1 Forward Liquidity Gap Variance Analysis in <Currency Type>

Table 18-2 Forward Liquidity Gap Variance Analysis

Field Names	Description
Report Name	Forward Liquidity Gap Variance Analysis in <Currency Type>
Report Level Filters	Reporting Bucket Definition: This is a drop-down selection. The drop-down list is displayed based on the Time Bucket Definition selected in the given Run. Bucket Level: This is a drop-down selection. The drop-down list is filtered based on the Reporting Time Bucket selected. Date 1: This is a drop-down selection of forward dates. The dropdown list is filtered based on the AsOfDate,Process/Run,Scenario and Run Execution Id selected as page level parameters. Date 2: This is a drop-down selection of forward dates. The dropdown list is filtered based on the AsOfDate,Process/Run,Scenario and Run Execution Id selected as page level parameters. Varaince As: This is a dropdown selection. There are two options available : Percentage Amount
Report Description	This report that displays the absolute and percentage variance between liquidity gaps in each time bucket across two forward dates. The name of this report changes based on the Currency Type selected as part of the Page Level Filters. For instance if the currency type is selected as Reporting Currency, the name of this report is displayed as Forward Liquidity Gap Variance Analysis in Reporting Currency.
Report Type	Graphical Report: Combination of Line and Column Chart Time Buckets of the selected bucket level are displayed on the x-axis. Liquidity gaps or cumulative gaps are displayed on the primary y-axis as column values based on the gap type filter selected. Variance is displayed as a line on the secondary y-axis in terms of absolute amount or percentage based on the variance as filter selection. Variance is calculated as follows: Variance Amount = Amount as on Date 2 – Amount as on Date 1 Variance Percentage = (Amount as on Date 2 – Amount as on Date 1) / Amount as on Date 1 Tabular Report: The following are displayed as row items: Total Inflows Total Outflows Liquidity Gap Cumulative Gap The time buckets corresponding to the bucket level selected as part of the report level filter are displayed as column items. Variance between 2 dates is displayed as column values as an amount or percentage depending on the variance as filter selection.
Dimensions	Time Buckets Calendar Forward Date Legal Entity
Base measures	Cash Flows Gap / Cumulative Gap
Computed measures	Total Inflows Total Outflows Liquidity Gap Cumulative Gap
Drill through on	Graphical Report: Graphical format is not available for this report. Tabular Report: Tabular format is not available for this report.
Drill through’s	Graphical Report: Graphical format is not available for this report. Tabular Report: Tabular format is not available for this report.