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
- Create a new Story report
- In the query designer select a table e.g. Job Information
- Select a couple of fields e.g. Business Unit Code and Name
- Go to Advanced Filtering
- Try to apply a filter on these fields
- 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):
- Create the query
- Click on Finish to go to Story designer
- Select the widget e.g. Table
- Edit > Builder
- Click on +Add Filters
- Click on Advanced Filtering
- You should find the autojoin columns this time
See Also
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
Attachments
| Pasted image.png |
| Pasted image.png |
SAP Knowledge Base Article - Public