SAP Knowledge Base Article - Public

3213327 - How to fetch Users' information in Goal Management schema - Story report

Symptom

  • 3 "Basic User Information" tables are displayed while creating a Story Report with Goal Management schema
  • User data is wrong in Story report with Goal Management schema

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create a new Story Report
  2. Select Goal Management
  3. Add the "Primary Goal Fields" table to the report
  4. Click on the "+" button to see the related tables
  5. You will notice that there are 3 "Basic User Information" under "User"

Resolution

Each table fetches data about a different user:

  • The First table shows the "Objective Owner" information;
  • The Second shows the "last modified by" user information;
  • The Third shows the "Created by" user information. 

If your report is showing incorrect user data, you'll need to delete the Basic User Information and add it again from scratch. When we add any of the "Basic User Info" tables, save the report, the selected table goes to the top when we click on the related tables option (it doesn't matter if we selected the 2nd or the 3rd Basic User Info table while creating the report, when we edit it, it'll be displayed as the 1st table).

Keywords

KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

Product

SAP SuccessFactors HXM Suite all versions