16.9.2 Current Period Report

The Variance Analysis Dashboard provides data based on selecting the values from the following list of drop-downs:

Note:

You must manually select the reports and then click Continue.

The Variance % is calculated with the following formula:

Variance % computed = (Current Value – Previous Value)/Previous Value

  • Report: Based on the KI Configuration this drop-down populates, select a Pre-configured Report.
  • Schedule: Based on the KI Configuration this drop-down populates, select a schedule.
  • Cell Identifier: Based on the KI Configuration this drop-down populates, select a Cell Identifier.
  • Entity Name: Select an Entity Name.
  • *Current Date: Select a Date on which the assessment has been done.
  • Variance %: Select a variance %
  • Variance Amount Between: Enter the Variance Amount Range.
  • Breached: Select 'Yes' or 'No' or both.

    Note:

    Ensure you have configured the Key Indicators. Refer to the Configuring Key Indicator Section.
  1. Click Apply to generate the reports.
  2. Click Reset to reset the values.

    The generated report contains the following details:

    • Report Code: Provides report code of the cell.
    • Schedule Code: Provides schedule code of the cell.
    • Cell Identifier: Provides the MDRM code of the cell.
    • Cell Line Item: Provides line item of the cell. To display the line item data must be maintained in the FSI_REG_CELL_LINE_ITEM table.
    • Cell Description: Provides the description of the code.
    • Entity: The entity for which the assessment was done.
    • Current Value: Provides the current value of the assessment.
    • Previous Value: Provides the previous value of the assessment.
    • Variance: Provides the difference between the current and previous values.
    • Variance %: Provides the percentage value of the variance.

      Figure 16-57 Variance Analysis Dashboard


      This illustration displays data based on selecting the values from the list of drop-downs.

    • Issues: Provides the count of issues against each cell. There is a drill-down that displays the details of the issues.

      Figure 16-58 Variance Analysis – Issue Details


      This illustration displays the count of issues against each cell. There is a drill-down that displays the details of the issues.

    • Actions: Provides the actions taken for each issue. The drill-down shows the action count.

      Figure 16-59 Variance Analysis – Action Details


      This illustration displays the actions taken for each issue. The drill-down shows the action count.

    • Trend: Displays the graphical representation of the assessment across time. You can select between:
      • Trend for All Dates
      • Trend for Date Range

        Note:

        Trend graphs can be exported to PDF and Excel.

      Figure 16-60 Trend


      This illustration displays the graphical representation of the assessment across time. You can select between Trend for All Dates and Trend for Date Range.

    • Create Issue: Create an issue from the dashboard itself against any cell irrespective of whether it has been breached or not. This issue can be modified on the DG Issues Page. After you create an issue through this method, you can view the number of created issues in the OBI Dashboard. For more information, see section Creating an Issue through the Dashboard section.