SAP Knowledge Base Article - Public

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

Symptom

Metadata(Configuration) changes made in Employee Central are not reflecting in Advanced Reporting.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
  • Advanced Reporting

Cause

The Metadata sync was not automatic and required manual refresh of the tables by SAP.

For even a very small Metadata change (Configuration change) in Employee Central, Customer needs to reach out to SAP SuccessFactors to get the Metadata refresh so that any configuration change made in Employee Central gets reflected in Advanced Reporting

Resolution

If your Advanced Reporting instance is upgraded to VBM, you need not to raise an incident with SAP to sync the Metadata changes.

Please ensure there is DATA in the fields even dummy DATA (TEST) as no changes will be reflected unless there is.

How the Metadata changes will be taken care if instance has VBM enabled:

  1. Automatic refresh:
    1. Any Metadata change in EC will be reflected in Advanced Reporting within 24 hours(max).
    2. A daily Job is scheduled for all Data center which sync the Metadata change from EC to Advanced Reporting.
  2. Manual refresh (for immediate sync):
    1. Customers can now use the Purge Advanced Reporting Metadata Cache option to sync the Employee Central metadata changes, so the updates immediately reflect in Advanced Reporting

''

Release Information: 

https://help.sap.com/viewer/7a5e1d53ab524d72bb5b98547e9f9c42/1902/en-US/5420155750b24325a223ff50e1c62c4f.html 

Note: 

The View Based Metadata (VBM) in Advanced Reporting is being enabled for SAP SuccessFactors tenants on HANA, in planned phases.
If you are getting an option of “Purge Advanced Reporting Metadata Cache” under Workforce Planning and Analytics Administration Page, that means your Advanced Reporting instance has VBM enabled.

Accessing the option:

  • If the instance still does not have Report Center enabled, you can access the link from the ORD / WFA Admin page directly.

  • If the instance has Report Center enabled, you can access perform the Purge using these steps:

    1. Access Report Center and click 'View Schedules'

      view_scheds.jpg

    2. Switch to the legacy Report Distributor Tool

      switch.jpg
    3. Access the Admin Section

      there.jpg

    4. Purge Advanced Reporting Metadata Cache

      Refresh.png

For More Detailed Information on VBM and other FAQ: 

https://blogs.sap.com/2019/03/27/1902-sap-successfactors-advanced-reporting-metadata-sync/

Keywords

Purge, Cache, Advanced, Reporting, Metadata, Sync, Employee, Central, View, Based, VBM, reload, refresh, EC, Report, Canvas, ORD, REALMS , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Product Enhancement

Product

SAP SuccessFactors HCM Suite all versions