Add a Measure for a Portfolio or Strategy

Video

Use the workspace Measures dictionary to add measures for portfolios and strategies. Measures use expressions to quantitatively monitor data important to you. A measure's aggregation source indicates the object type whose data is being captured. Portfolio and strategy measures support projects as an aggregation source and capture data from the projects within a portfolio or associated with a particular strategy node.

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 attributes or using existing dictionary measures. Project attributes include project-level fields and project 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 measures available in the Measures dictionary, or they can use measures referencing specific portfolios or strategies. 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.

After the measure is created, it must be associated with a portfolio or strategy within the workspace before it can monitor project data. See Associate a Measure with a Portfolio or Associate a Measure with a Strategy for more information.

To add a measure for a portfolio or strategy:

  1. In the object selector, select a workspace.
  2. In the sidebar, select Summary & Settings.
  3. On the Summary & Settings menu, select Dictionaries, and then select Measures.
  4. Select Add.
  5. 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 project or program data in the measure.
  6. 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.

  7. 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 Portfolio or Strategy Measure for more information.
    • Base Expression: The base expression for the Actual or Target formulas when Percentage is the selected Data Type.
  8. 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. In the list, select Referenced Measures to select measures that are currently assigned to portfolios or strategies.

      2. Select Portfolio or Strategy to specify the context for the measure associated to the formula. You cannot have a mix of portfolio and strategy contexts in a measure.

        Note: Portfolio context measures pull values from the projects associated with the portfolio, and Strategy context measures pull from the projects associated with the strategy. If a measure is displayed in a context not specified in the formula, the measure will not display a value.

      3. Select Insert.
      4. Select the mathematical symbols for the expression.
      5. 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 Portfolio or Strategy to specify the context for the measure associated to the formula. You cannot have a mix of portfolio and strategy contexts in a measure.

        Note: Portfolio context measures pull values from the projects associated with the portfolio, and Strategy context measures pull from the projects associated with the strategy. If a measure is displayed in a context not specified in the formula, the measure will not display a value.

      3. Select Insert. The formula template appears.
      4. 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.
      5. Add any other fields or symbols needed for the expression.
  9. Select Validate Formula.
  10. Select Save.
  11. In the Summary & Settings panel, select Close.

Tips

This setting is used in the following apps:

Dashboards
Portfolio Analysis
Strategic Alignment