Adjusting Risk and Value Scoring Key

You can change or add scoring criteria and their values for Risk Score and Value Score.

To do so, you should have the Configure Portfolio Management access grant.

Changing an Existing Criterion

To change the properties of an existing criterion:

  1. Log on to PPM.

  2. From the menu bar, select Open > Administration > Portfolio Management > Configure Scoring Criteria. The Configure Scoring Criteria page opens.

  3. Locate the criterion whose value you want to change and click the Edit button below its name.

    Suppose, for example, that you want to edit the Architecture Risk criterion.

  4. Make the desired changes to the criterion.

    • You can change any of the following fields:

      • Weight: weight of the criterion

      • Domain: whether the criterion impacts risk score or value score calculation

      • Criterion Name

      • Value: value of each drop-down text of the criterion

      • Selection: drop-down text of the criterion

    • You can also add values and selections to the criterion.

      Suppose in this example that you want to add a value of 7 that represents "Negative impact to standard architecture." Type these entries in the Value and Selection fields under the Add New Selection heading, and click Add.

      The new Value and Selection are added to the list.

  5. Click Done.

  6. Click Save to save the changes made to the scoring key.

Adding a New Criterion

Note: Making adjustments to the scoring key requires knowledge of SQL, which is used in the request type rules that govern the calculation of the Value Rating, Risk Rating, and Total Score fields.

  1. Log on to PPM.

  2. From the menu bar, select Open > Administration > Open Workbench.

  3. Create a new validation for the values for the new criterion.

    1. From the shortcut bar, select Configuration > Validations.

      Note: The validation can be a drop-down list or a single-select auto-complete list, and it must be validated by SQL.

    2. Click New Validation to create a new drop-down list validation.

    3. Specify the validation fields.

      1. In the Name field, type the new validation name. For example, PR Impact.

      2. Click out of the validation's Name field to get the Reference Code field automatically filled.

        Note: All reference codes for validations used for scoring criteria must begin with PFM_SCORE_.

      3. To enable the validation as a scoring criterion, add PFM_SCORE_ to the beginning of the reference code. For example. PFM_SCORE_PR_IMPACT.

      4. For the Component Type field, select Drop Down List.

      5. For the Validated By field, select SQL.

      6. Specify the following SQL:

        SELECT score_selection_id, score_selection_name
        FROM kpfm_scoring_keys_v
        WHERE validation_reference_code='<validation_reference_code>'

    4. Click OK to save the validation.
  1. Create a new field that uses the new validation for a lifecycle entity you want to be affected by the new criterion.

    1. From the shortcut bar, select Demand Mgmt > Request Types.

    2. Click List and select and open a request type, such as PFM - Proposal, that is affected by the new criterion.

    3. On the Fields tab, click New. The Field: New page opens.

    4. In the Field Prompt field, type the field name. For example, PR Impact.

    5. In the Validation field, select the validation you created in step 3. For example, PR Impact.

    6. In the Token field, type the reference code for the validation. For example, PFM_SCORE_PR_IMPACT.

    7. Click OK on the Field: New page.

    8. Click Save on the Request Type page.

  2. Edit the request type rules for the lifecycle entity you want to be affected by the new criterion.

    1. Click the Rules tab on the request type.

    2. Edit either the Calculate Value Rating rule or the Calculate Risk Rating rule, depending on the domain of the new criterion, by adding the new token to the SQL.

      Example: To add the PFM_SCORE_PR_IMPACT token to the Calculate Value Rating rule:

      1. Double-click Calculate Value Rating.

      2. In the Dependencies section, click New, select PR Impact as the Field, select contains any value as the Condition, and click OK.
      3. Add the following SQL immediately before the last close parenthesis in the existing SQL:

        ,NVL('[REQD.P.PFM_SCORE_PR_IMPACT]',0)

      4. Click OK.

    3. From the Rules tab, similarly edit the Calculate Total Score rule by adding the new token to the SQL.

      Example: To add the PFM_SCORE_PR_IMPACT token to the Calculate Total Score rule:

      1. Double-click Calculate Total Score.

      2. In the Dependencies section, click New, select PR Impact as the Field, select contains any value as the Condition, and click OK.
      3. Add the following SQL just before the last )) s in the existing SQL:

        , NVL('[REQD.P.PFM_SCORE_PR_IMPACT]', 0)

      4. Click OK.

    4. Click OK on the Request Type page.

  1. Repeat step 4 and step 5 for each lifecycle entity that will use the new criterion.

  2. Define the criterion's values in the Configure Scoring Criteria page. For details, see Changing an Existing Criterion.