Adhoc report fetches wrong values in Positions fields, even when the data is correct in Manage Positions tool.
- SAP SuccessFactors HXM Suite
- Adhoc Report
Reproducing the Issue
- Create a new Adhoc Report (Report Table)
- Select any MDF field under the column set - Job Information Position
- You’ll notice that some columns will show inconsistent data
There is no available workaround as this is expected as behavior.
We usually avoid reporting on "Job information Position" columns if this data only exists in an MDF object. Since Adhoc is not a tool designed to report on MDF, this limitation can lead to inconsistent results.
The alternative solution is to report on this data via Advanced Reporting, which was built especially for MDF objects and EC.
If you feel that this behavior should be changed, we recommend you submit an enhancement request following the document below:
MDF, position, adhoc, report, job, information, , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem