SAP Knowledge Base Article - Public

3729024 - Query designer inside the content store stories of embedded Analytics Cloud is not displaying consistent columns for the same entity in SFSF

Symptom

In imported standard story template SF_XM_My_Team_Dashboard_v2.0,  Job Information datasource shows inconsistent columns

Environment

  • SAP SuccessFactors HCM Core 2505
  • SAP Analytics Cloud 2026.2.6 

Reproducing the Issue

  1. Log in to the SFSF instance
  2. Navigate to "Report Centre".
  3. Open the story "SF_XM_My_Team_Dashboard_v2.0".
  4. Edit the data source for "Job Information (As of Date)".
  5. Click on "Job Information".
  6. Search for "test" 
    Notice : The fields "testA", "testB", and "testC" appear.
  7. Clear the search field and search for "Grade".
    Notice : Only "Previous Grade Group" is available, and "Grade Group" is missing.
  8. Close the Query Designer screen and return to the story.
  9. Edit the data source "Job Information (Time Range)".
  10. Search for "test"
    Notice: The fields "testA", "testB", and "testC" are not visible.
  11. Clear the search field and search for "Grade".
    Notice : The "Grade Group" field is available.

Cause

The issue is under investigation by Development Team.

Resolution

  1. Delete the problematic data source in the Query Designer.
  2. Re-add the data source to refresh the metadata.
  3. Recreate the query by deleting and re-adding the parent table to reset the metadata.
  4. Validate the recreated query to ensure the missing and extra columns are resolved.
  5. If the issue persists, follow this KBA for updates.

See Also

Keywords

missing columns, extra columns, job information, grade group, testA, testB, testC, SAC query designer, data source issue, story report, SF_XM_My_Team_Dashboard_v2.0, metadata mismatch, query recreation, content store story , KBA , LOD-ANA-QD , SAC Query Designer , Problem

Product

SAP Analytics Cloud 1.0