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.
SuccessFactors Workforce Analytics (ANA) - All versions
Reproducing the Issue
Go to Advanced Reporting and create a query using Employment > Global Job Information table
- Select the Event Reason fields:
- Check the Results. The Event Reason fields will be blank:
View Based Metadata is enabled in Advanced Reporting. Please refer 2573340 - View Based Metadata (VBM) 1711 Release Notes
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:
Expand the Global Job Information > Foundation Objects > Event Reason > and select the Event Reason field:
The Objects will be arranged like below:
Check the Results:
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