< back

Rollup Verification (Master Plan only)

MASTER PLAN SETTINGS

Verify Rollup Hierarchy

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.header.

The Hierarchy tab displays a list of Rollups, as they were established in: Plan>Reporting Levels.

Each hierarchy conflict identified for a Rollup will be labeled with an alert icon [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.

  • Note: To edit Rollups or change their order, return to the Reporting Levels screen for Rollups.

Resolve Hierarchy Conflicts

When BALANCEaap builds the Rollup hierarchy from data, the application will identify any Rollup level values that rollup to multiple different places.

Example: If you created two Rollup levels—Division and Country—and Division 1 shows in both Country A and Country B, this will be identified as a conflict. Any lower level rollup should only have one parent rollup value.

Any data records that are missing rollup values will also be identified as a conflict under the “Blank Parent Conflicts” section. Records can still be counted when a parent code is blank, but may not appear in the right rollup group for that rollup level.

To view and resolve these hierarchy conflicts, click on the Conflicts tab. On this screen you will see each conflict found, listed by Rollup Level. Additionally, a separate section will list the number of “Blank Parent Conflicts”.

To resolve each Rollup conflict, click the Resolve This Conflict link. You will be prompted to select one of the assigned parent values for that lower level rollup. All records that have that lower level rollup value will have the selected parent value assigned to the parent rollup field. The Fill in missing values option will be checked by default, and will also assign the selected parent value to any records that were currently missing a value for the parent rollup value. If you wish to not update any records that have a blank parent value, you should uncheck this option. Once you have selected a parent value, click Save.

To resolve all of the items flagged under “Blank Parent Conflicts”, click the Resolve This Conflict link. The system will attempt to find a common parent rollup value across the other lower level rollups that have that same value. If multiple parent values are found, or no other records with a parent value are found, the system will not be able to resolve the conflict and display a message indicating as such.

Using the example above, when trying to resolve the conflict for Division 1, the system will prompt you to select either Country A or Country B as the country value, and then will assign this value to any records with a division of Division 1. By default, the Fill in missing values button will also assign the selected country to all data records that have a division of Division 1.

Note: Although Data Table records will appear in reports, conflicts must be resolved for accurate Rollup reporting.