2265584 - Unable to add standard Objective Dashboard from Success Store

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.

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:

• SuccessFactors HCM Core
• Dashboard 2.0

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"

• 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.

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 case with Employee Profile (EP) the Cloud Product Support team (Succession module)
The attached CCOR has to be filled out and attached to the case.
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.

KBA , objective dashboard , objective dashboard error , invalid column , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem