SAP Knowledge Base Article - Public

2704828 - Event Reason field from Global Job Information table is blank - Advanced Reporting

Symptom

  • The Event Reason field from Global Job Information table is showing blank results in Advanced Reporting
  • The field was showing data as expected previously
  • View Based Metadata is enabled 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

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Go to Advanced Reporting and create a query using Employment > Global Job Information table
  2. Select the Event Reason fields:
    objects.png
  3. Check the Results. The Event Reason fields will be blank:
    event reason.png

Cause

View Based Metadata is enabled in Advanced Reporting. Please refer 2573340 - View Based Metadata (VBM) 1711 Release Notes

Resolution

This is a current limitation of Advanced Reporting with VBM enabled. Engineering is working on this case and the fix is planned for the next b1811 release.
The workaround is to disable VBM or to use the Event Reason table from the Foundation Objects:

  1. Expand the Global Job Information > Foundation Objects > Event Reason > and select the Event Reason field:
    expanding.png

  2. The Objects will be arranged like below:
    event FO.png

  3. Check the Results:
    result.png

See Also

2573340 - View Based Metadata (VBM) 1711 Release Notes

Keywords

Event Reason field from Global Job Information table is showing blank results in Advanced Reporting View Based Metadata is enabled VBM , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions