< back

Rollup Verification (Master Plan only)

KEY TOPICS:

  • View Rollup Hierarchy
  • Resolve Hierarchy Conflicts

Check the Hierarchy of Rollups and Resolve any Conflicts

About Rollup Verification

If Rollups have been created for a Master Plan, the side navigation menu displays a 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 table

Resolve a Blank Parent Conflict — Click the Resolve This Link 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 that list
  • Review the affected Data Tables

Use the [Rollup name] Conflicts table

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 for Fill in missing values is checked by default. You may uncheck this option if it is not applicable. Click [Save] to apply the changes.