Reporting Levels > Drilldowns (Optional)

KEY TOPICS:

• Add a Drilldown
• Import Drilldowns from an Existing Plan
• Other Drilldown Tools
• For an Excel data collection template, see — Regular Plan with Enhanced Data Fields
• Master Plan Reporting Levels > Rollup (includes data collection template for Rollups and Drilldowns)

---

Create Organization-specific Reporting within a Plan

(Optional) If you would like reporting within a plan to mirror departmental units or points of command, access: Plan > Reporting Levels > Drilldowns.

What is a Drilldown?

By using a Drilldown, an Affirmative Action plan is broken down into smaller units so that Reports can be organized by these units. The system offers a menu of standard Drilldowns, and custom Drilldowns may be created, as described in this article.

Important Reminder: The “Department” Drilldown is built in to balanceAAP and available by default.

About Standard Drilldown Fields

The system supplies the following standard Drilldowns, based on typical fields included in a plan’s Reference Tables and Data Tables:

• Department (Permanent)
• Job Group
• Grade
• Job Title

Note: The system will make Grade available if a Grade Reference table is included and the Data Tables include a Grade field.

About Custom Drilldown Fields

Up to five custom Drilldowns to represent organizational units can also be defined (e.g., Division, Store [number], Branch).

Important Caution: For best results, add the custom Drilldown prior to importing the associated Reference and Data tables. If the custom Drilldown is added afterwards, balanceAAP will attempt to match the Drilldown to an existing user field. However, if a custom Drilldown lacks underlying an underlying field or data entries, all Data records will be placed in Errors.

Add a Drilldown

From the Drilldowns tab, click the [Add] button. Enter a: Drilldown Name.

Quick Tip: Both the Drilldown Name and the associated field name (described below) may be the same for ease of organization.

Using the Create Drilldown menu, choose one of the following:

• Create New Field – Enter the field name.
The name(s) for the Reference table and the Data table field will appear on the Match Tables menu (Data Tables > Import) so that you can ensure the proper data are imported.

OR

• Use Existing Field – Select a field from the provided drop-down.
Once a Drilldown is created from an existing field, it cannot be deleted for that plan. However, except for the default Department Drilldown, the Drilldown may be deactivated, as described below.

Click [Save].

Using Reports > Filter, you can later select the Drilldown Name, and run Reports, based on the Drilldown.

Import Drilldowns from an Existing Plan

From the Drilldowns tab, selecttab:

1. Select the [Import] button.
   1. The Import Source menu displays. From the provided drop-downs, choose the plan that contains the Drilldowns by selecting the Company, Establishment, and Plan. Click [Next].
   2. A confirmation messages states: All Drilldowns will be overwritten. Click [Import Drilldowns].
   3. A Results message appears, documenting the transaction. Choose: Go to Plan Home, or Go to Drilldowns and view the updated page.

   Other Drilldown Tools

   Activate or Deactivate a Drilldown

   To make the Drilldown available (and the associated field required), ensure that the Drilldown’s Active box is checked on the list. To aid in the performance for other functions, deactivate a Drilldown by deselecting the check box in the Active column.

   Edit or Delete a Drilldown

   To edit the name of the Drilldown or other settings, click the [Edit] icon next to the Drilldown Name, and make changes in the Edit Drilldown menu. To delete a Drilldown, click the [Delete] icon, and confirm deletion.