Create a breakdown mapping

Breakdown mappings specify which field on the indicator source references the breakdown source.

Before you begin

Assign a breakdown source to the breakdown before creating the mapping.

The required roles are the same as for creating a breakdown.

About this task

You can create multiple mappings for the same breakdown, enabling you to use that breakdown for multiple indicators.
Note: A breakdown mapping can specify a script instead of a field.

Procedure

  1. If you are adding a mapping to an existing breakdown, find that breakdown in the relevant list of breakdowns and open it.
  2. In the Breakdown Mapping related list, click New.
  3. Select the Facts table. This table is the indicator source that you want to break down.
  4. Do one of these actions:
    OptionDescription
    Use a field to map values to elements. Select the Field in the indicator source that maps to records in the breakdown.

    See the use of the Category field in Example: Field mapping.

    Use a script to map values to elements. Select Scripted, then select the Script that defines the association between indicator records and breakdown elements.

    Use a script when you do not have the simple use case of a field in the indicator source that maps to a breakdown source table. A script can define a wide range of mapping relationships. The most common use case is when the breakdown source is a bucket group and the script returns an integer to assign an indicator score to a bucket. See Example: Script mapping.

  5. Click Submit.
  6. Repeat steps 3–6 as needed, to define additional mappings.