SAP Knowledge Base Article - Public

3075040 - Columns missing Advanced Filtering - People Analytics

Symptom

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

Environment

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

Resolution

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

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png