SAP Knowledge Base Article - Public

2934562 - Error Calculating Scorecard and multiple Measures selected after saving Custom Scorecard Options

Symptom

  • In WFA or Report Designer/ Report-Canvas, upon saving Scorecard table settings the component displays "Error Calculating Scorecard"
  • When editing the scorecard table again, multiple measures are selected instead of just the one you selected initially.
    E.g. you added EOP Headcount but later on All Input Measures from Workforce Profile are added to the query.

Environment

SAP SuccessFactors Workforce Analytics

Reproducing the Issue

  1. Create a new Canvas or WFA report page and add the Scorecard table component
  2. in the Scorecard Table Options window, select a Scorecard Type.  In this case, choose Custom
  3. Click on Select Measures button
  4. Leave default settings and add a Measure from the list (select and click Add button).
  5. Click OK to save your settings and go back to canvas designer page.
  6. Preview the report or select Run Table.
    • Result: Error Calculating Scorecard
  7. Edit the component again and click on Select Measures again.
    • Result: Notice that the 'Measures in Scorecard' list is populated with more measures in addition to the one you selected earlier

Cause

The Measures Options selected affects the result.

Resolution

There are 2 options in the Custom Scorecard Options

  1. Save as categories where possible - this will add all measures from the folder you added a measure from
  2. Save as Measure - this will retain only the measure(s) that you specifically added

The default is "Save as categories where possible". This will include All Input measures upon saving, which is why when you open it again all Input measures are added.
If you only need to include 1 measure, e.g. "EOP Headcount", then you need to select "Save as Measures" instead.
Moreover if the first option results to an Error due to the number of Measures selected, we suggest option for the second setting.

Keywords

scorecard table, error, calculating, scorecard, measures, input measures, default measures, custom scorecard, WFA, categories, measure , KBA , LOD-SF-WFA-ADM , Admin Tools , Problem

Product

SAP SuccessFactors HXM Core all versions