SAP Knowledge Base Article - Public

3075040 - Columns missing Advanced Filtering - People Analytics


  • Cannot find Autojoin columns in Advanced Filtering in Stories
  • Some fields are missing in Advanced Filtering e.g. Business Unit, Department, Location


SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create a new Story report
  2. In the query designer select a table e.g. Job Information
  3. Select a couple of fields e.g. Business Unit Code and Name
  4. Go to Advanced Filtering
  5. Try to apply a filter on these fields
  6. Cannot find the fields Business Unit Code or Name


This is a product limitation in Stories in People Analytics. However, SAP is already working to make the autojoin fields available in Advanced Filtering in the query designer.

In the meantime, please follow this workaround:

  1. Create the query
  2. Click on Finish to go to Story designer
  3. Select the widget e.g. Table
  4. Edit > Builder
  5. Click on +Add Filters

  6. Click on Advanced Filtering

  7. You should find the autojoin columns this time

See Also

3050294 - Stories in People Analytics - Known Issues - SAP ONE Support Launchpad


Cannot find Autojoin columns Advanced Filtering filter Stories foundation objects fields are missing in Advanced Filtering Business Unit Department Location People Analytics , KBA , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , Product Enhancement


SAP SuccessFactors HXM Suite all versions


Pasted image.png