Symptom
You try to crete a new query via Advanced reporting (realm) however when you expand the drop down list, to select the required object, you notice that only technical names or names with capital letters are shown.
Environment
- SAP SuccessFactors HCM Core
- Advanced Reeporting (Realms)
Reproducing the Issue
- Login to the desired instance
- Analytics - Analytics
- Advanced Reporting > Employment > the below is shown instead of the labels:
EMPLOYMENT_VIEW_MERGE_EMP_JOB_INFO_T_GLOBAL
MEMB_EMP_EMPLOYMENT_INFO_ASSIGNMENT_TYPE
MEMB_EMP_EMPLOYMENT_INFO_CREATED_DATE
MEMB_EMP_EMPLOYMENT_INFO_IS_HOST_ASSIGNMENT
Cause
In this case, the metadata for most objects available in the query designer needed to be refreshed.
Resolution
In this case the issue was solved with a refresh of the Meta Data Framework (MDF) objects and afterwards a reload for the MDF views.
It looks like the replication from Bizx to ODS completed with some inconsistencies.
NOTE: The above steps are performed via the Analytics Back-end tools and usually by the Engineering Team.
Keywords
Advanced Reeporting, Realm, query, object , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-WFA-REP , Reports, Data, Insight , Problem