3201893 - Join between Basic User Information and custom MDF not available

A Story report has to be created with Basic User Information as the driving table and a custom MDF object linked to it.

However, there is no join found between Basic User Information and custom MDF.

• SAP SuccessFactors HXM Suite
  
  • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
    
    • People Analytics (Analytics Cloud for SF)
      
      • Query Designer - Filter, Calculated Column, Params

1. Login to instance
2. Create a new MDF in Configure Object Definition
3. Use a field of type User and name the field 'externalcode'
4. Now when you create a Story, you will not find join between Basic User Information and the newly created custom MDF.

Name of the field used is incorrect 

The Name of the field, of type User, should always be externalCode.

However, in this case it was externalcode (lower case c).

Hence the error.

Updating it to externalCode (with Capital C) should resolve the issue.

externalCode, join, mdf, story, basic, user, information, missing, custom, people, analytics , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem