SAP Knowledge Base Article - Public

2265584 - Unable to add standard Objective Dashboard from Success Store

Symptom

When trying to add the standard Objective Dashboard from the Successstore the following error message appears:


The report associated with this dashboard contains an invalid column, please contact support for more detail.

 

Objective Dashboards.PNG

Also, if an EPIX file of standard Objective Dashboard is uploaded from another instance where this dashboard is working then it throws below error message:

objective dashboard error.png

Environment

  • SuccessFactors HCM Core
  • Dashboard 2.0

Reproducing the Issue

Scenario 1:

  1. Admin Center
  2. Reporting
  3. Manage Dashboards
  4. Manage Dashboards and YouCalc Files
  5. Click Button "Add from Successstore"
  6. Click add to instance for the Objective Dashboard
  7. Observe the error message in symptom section

Scenario 2:

  • Let's consider Objective Dashboard is working in test instance. 
  • Download the the .epix file from test instance and upload in production instance.
  • Set the filter and click the apply filters button.
  • Dashboard throws below error message:
  • "An error occurred while calculating data, please try again later or contact your administrator.
    Details:errorCode004data
    txtLogical column is invalid for logical column id : null Logical Column Key :
    { name: goal#OBJECTIVE#OBJECTIVE_STATE, messageKey: null}
    Alias Name : null Generated Alias Name :
    goal Column Label : null Column Type: nullid3"

Cause

  • The issue is caused by a missing configuration in the Succession data model.
  • In this case the "State" field was not configured as a standard field.
  • The Objective Dashboards has a dependency on other modules like Employee Profile.
  • For Employee Profile there are many standard elements configured in the data model, like CITY, TITLE, STATE etc. 
  • For a Employee Profile report Adhoc Framework will look data model for labels of these columns and If the column used in the report is not there in the data model, framework will throw exception.

Resolution

If you are a partner you can configure the "state" field as a standard element in the Succession data model.
This should enable you to add the dashboard to the instance.

Example:

  • <standard-element id="state" max-length="128" required="false" matrix-filter="false">

If you are a customer please raise an incident with Employee Profile (EP) the Cloud Product Support team (Succession module)
The attached CCOR has to be filled out and attached to the incident.
In the CCOR you need to add the information to have the "state" field configured as a standard element.
Once the service request has been completed you should be able to add the dashboard as expected.

Please be aware that the change would usually be done within your test environment first before we apply the change to your production system.

NOTE - 

The below fields must contain data in order to execute standard objective dashboard or objective management tile:

  • Objective ID , Category , Visibility, Status, Objective Aligned up, Objective Owner Username, start date , Due date , Objective , %Complete , Objective Owner First Name , Objective Owner Last Name , Visibility Code , Objective Overall Progress.

Keywords

KBA , objective dashboard error , objective dashboard , invalid column , LOD-SF-ANA-DSH , Dashboard and YouCalc , Problem

Product

SAP SuccessFactors HCM Core 1511

Attachments

CCOR Service Request Form.docx