SAP Knowledge Base Article - Public

2276691 - Advanced Reporting is Out of Sync with Employee Central

Symptom

  • Data or objects in Advanced Reporting (legacy ODS or Realms) are not in sync with what appears in Employee Central.
  • Custom MDF object is not showing on the Advanced reporting (Realms).

Environment

  • SAP SuccessFactors HCM Suite

Cause

Advanced Reporting may display inconsistent data compared to what you see from Employee Central (EC) because Legacy ODS/Realms and Employee Central get out of sync.

This may occur for the below reasons:

  1. Any Employee Central Foundation Object (FO) configuration changes.
  2. Any Employee Central Metadata Framework (MDF) Object Configuration changes.
  3. Data Model configuration changes.
  4. Replication process stopped for some technical reason like connectivity issue etc.

Resolution

Most of the out of sync issues between EC and Legacy ODS/Realms appearing due to the mentioned causes may be resolved by reload.

Common Scenarios when reload is required:

  1. Any Employee Central Foundation Object (FO) configuration changes: Currently any change to the EC FO is not automatically taken up by Realms therefore manual reload is required to get Realms in sync with the updated configuration.
  2. Any Employee Central Metadata Framework (MDF) Object Configuration changes: Currently any change to the EC MDF Object is not automatically taken up by Realms therefore manual reload is required to get Realms in sync with the updated configuration.
  3. Data Model configuration changes: When any configuration changes are made in the data model and it's not reflected in Advance reporting.
  4. Replication process stopped for some technical reason like connectivity issue etc: Once replication is restarted, to sync the missing data, reload is required.
  5. Confirm that there is DATA in the fields before Reload, the field will not appear in the report unless there is DATA in the Fields,  Provide a screenshot (full page) of where the data appears in Employee Central.

If VBM is enabled in your instance's Advanced Reporting, metadata will be refreshed automatically, once in every 24 hours.
Additionally, you can also perform a manual refresh from the instance itself, with no dependency on us (the support team)
The following article explains how to check the status and to use the self service option:

2776882 - EC Advanced Reporting Metadata Sync (View Based Metadata)

The Following blog post explains it in a much more detailed manner:
https://blogs.sap.com/2019/03/27/1902-sap-successfactors-advanced-reporting-metadata-sync/

If your instance does not have VBM enabled, kindly create a support incident with as much details as possible, about the sync issue you are facing.
Specific examples would be of great help if any investigation is required.

The reload process requires from a few hours to about a business day (depending on the instance's configuration).
Please note during this time some functionality may be unavailable for the reload duration. 

N.B. Support cannot process the scheduling of reloads as there may be other strains on the data centre or the reload may take longer than expected. 

If there is a technical issue during the reload it will be detected and the process will be restarted, so delays are possible.  Support will alert you when the process is complete so you can confirm if site is working as expected.

Recommendation:

All EC configuration changes should be carried before the enablement of Advanced Reporting (refer to the KBA 2279026  and Employee Central Advanced Reporting Implementation).

If configuration changes are made after Advanced Reporting is enabled you may perform some sample checks on the report data and if you identify any inconsistencies you may create an incident with the below information:

  1. What configuration was changed? For example, Configuration changes to MDF object, Data Model, Field Name (changed/Added), MDF object etc.
  2. Was the report data correct before the changes?
  3. Did you compare the data from the report and the employee Central portlets?
  4. What Report and field shows Out of Sync data? (needed to replicate and check the issue)
  5. What User is facing the issue? (needed to replicate and check the issue)

NOTE: Frequent configuration changes are not recommended as it will make the ODS/Realms out of sync with EC and may require frequent reloads.

Keywords

Purge, Cache, Advanced, Reporting, Metadata, out, Sync, Employee, Central, View, Based, VBM, reload, refresh, EC, Report, Canvas, ORD, REALMS

, KBA , reload , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-WFA-RLD , Reload Requests , How To

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions