SAP Knowledge Base Article - Public

3743419 - Missing custom field from multiple joins of similar configuration type in Story Reports

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

  1. Check hard joins from JobInfo to FO Division - there is standard join available;
  2. Configure one custom join to Division from Employment;
  3. The new custom auto join available under Employment;
  4. The new custom hard join also available from Employment -> FO - this time two hard joins - one standard and the newly created custom one;
  5. Configure one more custom join to Division from Employment;
  6. Check under Employment -> all three auto joins are available ( standard for Division and other two for new two fields);
  7. Check the hard joins from Employment;
  8. 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

Product

SAP SuccessFactors HCM Suite all versions