16.6.2.1 Drill Down Report

In the Cell Identifier Column, click the Cell IDs.

You can view the following information:
  • GL Details: Provides the GL account details along with the cell ID.

    Figure 16-46 GL Details


    This illustration displays the GL account details along with the Cell ID.

    • The current and previous Period Values for the Source Data, adjustment, and Final Cell Value. The data in the final cell is a combination of the Source and Adjustment Data.

      Note:

      Measure the value displayed at the product level is the variance amount.

      The Final Value and Final Value (Previous Period) to the Intermediate and Account drill-down templates are displayed. The values from these cells tie back to the current and previous values in the tile. The column totals defined at each level ties back to the previous level.

      Figure 16-47 Account Details


      This illustration displays the Final Value and Final Value (Previous Period) to the Intermediate and Account drill-down templates are displayed. The values from these cells tie back to the current and previous values in the tile. The column totals defined at each level ties back to the previous level.

    • Adjustment Details: The Cell Level Adjustments which are passed in the system are displayed against the particular cell in the drill-down under Adjustment Details.
      The Assessment Methodology is configurable and depending on the business need you can change the methodology as and when required. As a validation, the total of all the adjustments must be equal to the adjustment tile value. In scenario the Adjustment ID is retained the same across all the time periods, the Adjustment Variance is computed both for amount and percentage.

      Note:

      If the Adjustment ID is not the same across all the time periods, then the Variance Amount and Percentage is not computed.

      Figure 16-48 Adjustment Details


      The Cell Level Adjustments which are passed in the system are displayed against the particular cell in the drill-down under Adjustment Details.