SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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

Reproducing the Issue

  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.

Cause

Name of the field used is incorrect 

Resolution

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.

Keywords

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

Product

SAP SuccessFactors HXM Suite 2205