2144444 - ORD reports (dashboards 3.0) are not correctly reporting on a value from a goal plan. - Goal Management

SAP Knowledge Base Article - Public

2144444 - ORD reports (dashboards 3.0) are not correctly reporting on a value from a goal plan. - Goal Management

Symptom

ORD reports (dashboards 3.0) are not correctly reporting on a value from a goal plan.

We have a custom field defined in our goal plan, and it is defined as a number. We use this is as a value in a SUM calculation also which is not working.

Example:

<field-definition id="stretch" type="number"

field-definition id="bizx-target" type="number"

The number is working correctly in Goals, and works as part of a calculation within Goals.

However, when we try to report on this same data via ORD reports (dashboards 3.0) the calculation does not work.Edit section

On goal side we allow customers to customize the id/label/type of custom fields in goal plan template. For this reason for such customize fields we only can store them in database as type=string since the field type could be changed at any time. The type NUMBER is not transportable to ORD, but is sent as TEXT type (varchar).

 

Environment

  • Performance Goal Management

Cause

On goal side we allow customers to customize the id/label/type of custom fields in goal plan template. For this reason for such customize fields we only can store them in database as type=string since the field type could be changed at any time. The type NUMBER is not transportable to ORD, but is sent as TEXT type (varchar).

Resolution

Working as designed. ORD can not apply sum function on the data stored as varchar text in database which typically is the case for custom fields.

There may be no workarounds for some clients as using the custom field on the Goal side may be a requirement you cannot change.

Some clients may be able to use a standard field that stores numbers, instead of a custom field set as type=number as a workaround

Keywords

KBA , LOD-SF-PM , Performance Management , How To

Product

SAP SuccessFactors HCM Core all versions