Rollup Verification (Master Plan only)

KEY TOPICS:

  • About Rollup Verification
    • About Hierarchy Conflicts
  • Resolve Hierarchy Conflicts
    • Use the Blank Parent Conflicts Menu
    • Use the Rollup Conflicts Menu


Check the Hierarchy of Rollups and Resolve Conflicts

About Rollup Verification

If Plan > Rollups have been created for a Master Plan, the side navigation menu displays a Reporting Levels > Rollup Verification bar. On entry, the Hierarchy tab is active, with an additional tab for (resolving) Conflicts available in the tab header.

The Hierarchy tab displays the list of established Rollups. Each hierarchy conflict identified for a Rollup will be labeled with an [Alert] icon to its left. If you hover the mouse over the icon, a screen tip will appear that contains more information about the conflict.

Cross-reference: To create, edit, or change the order of Rollups, see: Master Plan Reporting Levels > Rollups.

About Hierarchy Conflicts

When BALANCEaap builds the Rollup hierarchy from data, the system will identify any values that roll up incorrectly, such as:

  • A child value that rolls up to two or more parent values
  • A blank parent value (The data records will be included in reporting, but may show up on the incorrect report.)

Example: If two Rollups were created — Division and Country — and Division 1 shows in both Country A and Country B, this will be flagged.

Resolve Hierarchy Conflicts

Navigate to the Conflicts tab, which will display Blank Parent Conflicts and [Rollup name] Conflicts in separate tables, with a link in each table to Resolve This Conflict.

Use the Blank Parent Conflicts Menu

Resolve a Blank Parent Conflict — Click the Resolve This Conflict link, and the system will attempt to fill in the necessary value(s), based on “like” records. In some cases, the system may indicate the issue cannot be resolved automatically. However, the issue may be correctable once other conflicts are addressed (as described below). If an issue persists:

  • Return to Reporting Levels > Rollups to check the list and its order.
  • Review the involved Data Tables.

Use the [Rollup name] Conflicts Menu

Edit the Parent Value (and Fill in Missing Values — Click Resolve This Conflict to open a menu. Select a (new) Parent Value from the provided drop-down. The checkbox is filled in by default for: Fill in missing values. You may uncheck this option if it is not applicable. Click [Save] to apply the changes.