Symptom
If multiple custom fields are configured under JobInfo of similar type e.g. type="Division", Story report query designer shows only the last configured custom field as hard join.
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Check hard joins from JobInfo to FO Division - there is standard join available;
- Configure one custom join to Division from Employment;
- The new custom auto join available under Employment;
- The new custom hard join also available from Employment -> FO - this time two hard joins - one standard and the newly created custom one;
- Configure one more custom join to Division from Employment;
- Check under Employment -> all three auto joins are available ( standard for Division and other two for new two fields);
- Check the hard joins from Employment;
- The previous custom join is no longer available. Instead, the new custom join made #5 is shown.
Cause
This is a limitation from the tool.
Resolution
This is a known issue by SAP and it is already under solution design by the engineering team.
Once the solution design get completed this documentation will be updated with the release date.
Keywords
multiple; custom; fields; joins; missing; jobinfo; job; info; link; query; design; output; similar; type; ECT‑269800; ECT-264874 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Product Enhancement
SAP Knowledge Base Article - Public