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
- 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 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:
- 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 People Analytics , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , Product Enhancement
Product
SAP SuccessFactors HCM Suite all versions
Attachments
Pasted image.png |