6.4 Gap Report of Top N Customers

Table 6-5 Gap Report of Top N Customers

Field Names Description
Report Name Gap Report of Top N Customers
Report Level Filters

Top N – Specified by the user as a numeric value

Large Customer Name – The top N customers are displayed in the drop- down for selection

Report Description This report displays the Top N details entered where N corresponding to the number of large customers for which the report is to be displayed.
Report Type

Graphical Report:

Combination of Line and Column Chart

The graphical chart displays the time buckets for the selected bucket level on the x-axis. The liquidity gap for the top N large customers is displayed on the y-axis as a column chart. The cumulative gap is displayed on the y-axis as a line graph.

Tabular Report:

The following are displayed as row items for each top N customer:

Inflows

Outflows

Liquidity Gap

The time buckets corresponding to the bucket level selected as part of the page level filter are displayed as column items.

NOTE: Customer selection only affects the graphical report. The tabular report remains unaffected. It displays the rows based on all top N customers.

Dimensions

Inflows

Outflows

Base Measures

Liquidity Gap

Cumulative Gap

Computed Measures Not Applicable
Drill-through On

Graphical Report:

Clicking each column in the column chart.

Tabular Report:

Row level drill- through on the Inflows, Outflows and Liquidity Gap. Column drill- through on each time bucket column.

Drill-through’s

The drill- through sequence for both the tabular and graphical reports is as follows:

Level 1: Product Type

Level 2: Product

Level 3: Account

Graphical Report:

On clicking each column the drill-through report will display the break-up of liquidity gap and cumulative gap across the dimension on the drill- through. All drill- through reports are a combination of line and column charts.

Tabular Report:

Drill- through is enabled on each dimension member against the following row items as per the existing drill- through sequence:

Inflows

Outflows

Liquidity Gap