Add a Program Measure

Program measures are configured at the workspace level and used to monitor project attributes on projects within a program. You can view program measures as columns in the programs inventory panel. For more information about measures, see Measures Overview.

Measures use expressions to quantitatively monitor data important to you. A measure's aggregation source indicates the object type whose data is being captured. Program measures support projects and programs as aggregation sources and capture data from the projects or programs.

The target and actual values used for measures can be configured for manual entry or using a formula. Manual values are entered on pages where the measures appear. Formulas are defined by creating expressions using project or program attributes or using existing program measures. The project and program attributes include project or program-level fields and project or program measures that exist in the workspace. Measures that use existing measures are called measure-based measures. Measure-based measure expressions can use one or more of the available program measures. When choosing a measure, you can select its target or actual expression. Attributes and measure-based measures cannot be used in the same expression.

For information on creating advanced formulas for measures, refer to the Oracle Primavera Cloud Expression Language Guide on Oracle Help Center.

To add a program measure:

  1. Navigate to the Program configuration page
  2. On the Measures tab, select Add.
  3. In the table, complete the following fields:
    • Name: The name of the measure.
    • (Optional) Description: Details about the measure.
    • Data Type: The type of data that the measure generates. Options include Cost, Number, and Percentage.
    • Target Type: Determines whether the Target value of the measure is manually entered or calculated using a formula. Entering a target value is not required.
    • Actual Type: Determines whether the Actual value of the measure is manually entered or calculated using a formula.
    • Measure Based: Determines whether the measure is created using existing measures. This option is available when either Target Type or Actual Type is set to Formula.
    • Tracking Frequency: Determines how frequently you want to monitor the measure. For example, if a formula-based measure's tracking frequency is set to Weekly, it is computed every week. If it is a manual measure with Weekly tracking frequency, you can enter measure values in weekly buckets.
    • Aggregation Source: Determines whether you are capturing projects or programs data in the measure.

      Note: You can recalculate program measures on demand in the programs inventory panel.

  4. If Target Type or Actual Type is set to Formula, select the Data Source detail window to configure their formulas.

    Note: The Data Source detail window is not displayed if both types are set to Manual.

  5. In the Data Source detail window, select any of the following sections, if applicable:
    • Actual: Formula that calculates the current values for the measure.
    • (Optional) Target: Formula that calculates a value that can be used when setting thresholds to measure against. See Set a Threshold for a Program Measure for more information.
    • Base Expression: The base expression for the Actual or Target formulas when Percentage is the selected Data Type.
  6. In the selected section, enter a formula manually or using a formula template.
    1. To enter a formula manually:
      1. Select the Field list to locate the field to use in the calculation.

        When the Measure Based option is selected, the Field list will only show measures available to use in the formula.

      2. Select Insert.
      3. Select the mathematical symbols for the expression.
      4. Add any other fields or symbols needed for the expression.
    2. To use a formula template:
      1. In the Aggregation Type list, select the calculation needed for the formula. The list is only enabled when Measure Based is not selected.
      2. Select Insert. The formula template appears.
      3. To use the template, highlight or delete Field or Filter, including the angle brackets, select a field from the Field list, and select Insert. Repeat for any additional fields or fields to filter by.
      4. Add any other fields or symbols needed for the expression.
  7. Select Validate Formula.
  8. Save your changes:
    1. Select Save.
    2. In the Summary & Settings panel, select Close.

Tips

This setting is used in the following apps:

Dashboards
Reports