16.9 Variance Analysis Dashboard

Variance analysis the process of identifying the causes of variations in the MDRM values between current and prior periods. It helps understand why fluctuations happen and what can or must be done to reduce the adverse variance. This eventually helps in finalizing the report cell (MDRM) values.

Note:

This Dashboard for USFED Reports.

Variance analysis helps users identify threshold breaches set at the Report/Cell level before generating the final numbers. Based on the breached cell values, you can decide the course of action by either rectifying it using Cell level adjustment or take no action. This enables you to confidently submit the final numbers to the regulators.

Prerequisites:

1. The Indicator assessment must be performed before verifying the variance analysis dashboard. Execute the batch DGS_KI_BATCH for the date on which the data needs to be analyzed. For more details, see the OFS Data Governance Run Chart.
2. Execute the account granularity batch ACCT_MAPPER_INSERT for generating Accounts, Accounts Write-off, Accounts Recovery, Party, Fund Lend Exposure, Credit Participation and Loan Serviced.. For more details on the parameter to be passed for generating the account level granularity, refer to the section Populating Data for Account Drill down Granularity (Variance Analysis dashboard).