In canvas Variable Prompts

6.3.1.2 In canvas Variable Prompts

Figure 6-14 In-canvas Prompt Filters for Top Down Summary and Detailed Income Statement

This image displays the In-canvas Prompt Filters for Top Down Summary and Detailed Income Statement

Select Time Level: You need to select Year/ Half Year/Quarter/ Month from this prompt to display the preference of the time block for the analysis.
Select Legal Entity Hierarchy: You can use this filter to select the LE Level Name pertaining to the LE Hierarchy level, for rolling up the results on the underlying Legal Entity Leaves that are part of the selected hierarchy.
Select Org Unit Hierarchy: You can use this filter to select the Org Unit Level Name pertaining to the Org Unit Hierarchy level, for rolling up the results on the underlying Org Unit Leaves that are part of the selected hierarchy.
Select Product Hierarchy: You can use this filter to select the Product Level Name pertaining to the Product Hierarchy level, for rolling up the results on the underlying Product Leaves that are part of the selected hierarchy.

Figure 6-15 In-canvas Filters for Time and Defined Org Unit canvas

Select Income Statement Reporting Line: This is a mandatory filter for the group filtering on the Income Statement reporting line dimension. The following filter values are available for selection:
- Net Income Before Tax: Net income before tax is the amount of profit made by the financial institution before income tax is paid. This figure is found by subtracting total expenses from total revenue.
- Operating Expense: Operating Expenses are expenses incurred by the bank or financial institution to carry out normal business operations.
- Non Operating Expense: A non-operating expenses are costs that are not directly related to core business operations of the bank. Typical examples of non-operating expenses for a bank are credit losses, recoveries, restructuring costs, write-offs and so on.
- Total Revenue: Total revenue is the total amount of income earned by the bank by selling products and services. It determines how well a company is bringing in money from its core operations of interest arbitrage and other income like fees and commissions.
- Net Interest Income: Net Interest Income (NII) is the difference between the revenue generated from a bank's interest-bearing assets and expenses incurred while paying its interest-bearing liabilities. A bank's assets consist of personal and commercial loans, mortgages, securities etc. A bank's liabilities typically consist of customer deposits.
- Non Interest Income: The non-interest income is the revenue generated by the banks and financial institutions, usually from the non-core activities (loan processing fee, late payment fees, credit card charges, service charges, penalties, etc. net off waivers).
- Total Expense: Total Expenses means the sum of cost of sales and operating expenses (general, administrative, sales and marketing expenses) and non-operating expenses.
- Credit Loss Provision: The provision for credit losses is an estimation of potential losses that a bank might experience due to credit risk. The provision for credit losses is treated as a non-operating expense on the company's financial statements.

Select Time Level: You need to select Year/ Half Year/ Quarter/ Month from this prompt to display the preference of the time block for the analysis.
Select Legal Entity Hierarchy: You can use this filter to select the LE Level Name pertaining to the LE Hierarchy level, for rolling up the results on the underlying Legal Entity Leaves that are part of the selected hierarchy.
Select Org Unit Hierarchy: You can use this filter to select the Org Unit Level Name pertaining to the Org Unit Hierarchy level, for rolling up the results on the underlying Org Unit Leaves that are part of the selected hierarchy.
Select Product Hierarchy: You can use this filter to select the Product Level Name pertaining to the Product Hierarchy level, for rolling up the results on the underlying Product Leaves that are part of the selected hierarchy.