Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • balanceAAP
  • Settings
  • Reporting Levels

Reporting Levels - Rollups

Written by Paul Gorman

Updated at December 4th, 2024

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • balanceWORKS
  • balanceAAP
    About balanceAAP Plans Home Settings Data Help for the AAP Data Import Job Group Structure Organizational Profile Availability History IWD/Veterans Narratives Publish Plan Reports Dashboard Plan Review Additional Information System Tools (for Administrators)
  • Berkshire Client Portal
    About Berkshire Client Portal Data Visualizations Reports System Tools BCP Tools
  • REACH
    About REACH Modules System Tools
  • Release Notes
+ More

Table of Contents

Use Rollups for Analysis across Plans What is a Rollup? Add a Rollup Create a Rollup prior to Data Import Create a Rollup using an Existing Field Import Rollups from an Existing Master Plan Other Rollup Tools

Use Rollups for Analysis across Plans

(Optional) While settings for Reporting Levels > Rollups and Plan Groups are not required to complete an AAP, they allow you to customize reporting across sub plans for executive- or management-specific needs.

What is a Rollup?

In a Master Plan, a Rollup represents a level of analysis above the sub plan, or beyond the regulatory framework of a single plan. These larger units form the basis for assembling plan results into the “big picture” across plans. Up to five Rollups can be defined and placed in hierarchical order.

Example: Results for a retail chain, with subsidiaries, are represented at the sub-plan level by Store; at the next levels by State and Region, and then by Subsidiary. Finally, the Subsidiary level rolls up into the full Master Plan.

You may create a Rollup that ties to a data field, as described below. By accessing Reports > AAP Reports > Filter, the Rollup unit can be used to organize plan Reports.

Add a Rollup

Create a Rollup prior to Data Import

Before performing Data > Import, access the Rollups tab. Click the [Add] button. The Create Rollups menu will appear; enter the Rollup Name. Using the provided radio buttons, select: Create New Rollup; and click [Save].

To place the Rollups list in hierarchal order, see the instructions below, under Other Rollup Tools.

Create a Rollup using an Existing Field

This method is for creating a Rollup after Data Import. From the Rollups tab, click the [Add] button.

Enter the Rollup Name. Using the radio buttons, select: Use Existing Field; then make a selection from the drop-down’s list of existing User Fields. Click [Save] to add the item to the Rollup list.

If desired, place the list in hierarchal order, as described below.

Import Rollups from an Existing Master Plan

From the Rollups tab:

  1. Select the [Import] button.
  2. The Import Source menu displays. From the provided drop-downs, choose an existing Master Plan (containing Rollups) by Company, Establishment, and Plan. Click [Next].
  3. A confirmation messages states: All Rollups will be overwritten. Click [Import Rollups].
  4. A Results message appears, documenting the transaction. Choose: Go to Plan Home, or Go to Rollups and view the updated page.

Other Rollup Tools

Place Rollups in Hierarchal Order — The Rollups list can be placed in hierarchical order, beginning with the highest level of desired analysis. Use the Top/Up/Down/Bottom arrows next to each Rollup to move it to a new location. Once the order is correct, click [Save].

Edit a Rollup — Click [Edit] icon next to the Rollup Name to make changes in an edit window.

Delete a Rollup — To remove a Rollup from the list, click the [Delete] icon, and confirm deletion.

aggregated plans hierarchy levels

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Plan Codes (Master Plan only)
MicrosoftTeams-image (4)

Berkshire is a human resources and technology firm specializing in affirmative action, pay equity, and workforce data analytics.

Solutions
  • Compliance
  • Pay Equity
  • People Insights
About Us
  • History
  • Careers
  • Our Team
  • Contact Us
  • Privacy Policy

© Copyright 2024

Expand