SAP Knowledge Base Article - Public

3075040 - Columns missing on Advanced Filtering on Story Reports

Symptom

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

Environment

SAP SuccessFactors HCM 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 known product limitation in Story Reports prior to the 2605 release. The limitation is addressed with the 2605 release, where auto‑join fields are supported in Advanced Filtering at the table level in Query Designer. For more information on availability and deployment timelines, please refer to the SAP SuccessFactors Help Portal (What’s New Viewer) for the 2605 release.

Workaround (Pre‑2605):

  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 

Keywords

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

Product

SAP SuccessFactors Platform all versions

Attachments

Pasted image.png
Pasted image.png