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][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 record 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
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.