Symptom
Story Report support to add 'Set Conditions for Advanced Filter'(Advanced Filter) under both Data Source Query Designer page and Page Filter settings.
Some of Conditions is support under "Query Designer - Advanced Filter setting" but not support under "Page Filter - Advanced Filters".
Advanced filtering allows you to filter multiple data fields by defining a set of logical conditions.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HCM
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD, Story Report)
- People Analytics - Story Report
Reproducing the Issue
- Add an Advanced Filter under data source Query Designer and Page Filter settings.
- Select an operator to filter data from the selected column.
- From data source Query Designer, you can apply "Equal to", "Except", "Is null", or "Is not null" as the operator.
- From Page Filter - Advanced Filters, you can only apply "Equal to" and "Does not equal"
Cause
Different behaviour settings of Query Designer and Page Filter settings.
Resolution
For the Page Filter - Advanced Filters, there's only "Equal to" and "Does not equal" being supported.
For Query Designer - Advanced Filters,
- For all columns, you can apply Equal to, Except, Is null, or Is not null as the operator.
- For String type columns, you can additionally apply Like.
- For Numeric, Integer, Decimal, Date and Datetime types of columns, you can additionally apply Greater than, Greater than or equal to, Less than, Less than or equal to, or Between.
See Also
Keywords
Conditions, Advanced Filter, Equal to, Does not equal , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To