SAP Knowledge Base Article - Public

2599531 - Applying wildcard filters to a Report - Ad Hoc/ORD/Advanced Reporting


Is it possible to apply a filter in Ad Hoc / Report - Table and Online Report Designer/ Advanced Reporting/ Report - Canvas based on a wildcard?


SAP SuccessFactors Workforce Analytics


For Ad Hoc reporting - this is possible by using the "Like" operator when defining the Filter condition.  Try adding the percent "%" character before and/or after the word that should be matched if you need results that include a specific word.

E.g. the report should return results with the word "department"- set it as "Like %department%" so that the results will show all records containing the word department


For Online Report Designer Live Data and Advanced Reporting - Yes this is possible by using the Like operator when setting a Custom Value in the filter designer.

e.g. Location like "AU". This will return values like AU01, AU02 etc.


ORD filters, static filter, runtime filter, wildcard filters, report filters, using like operator, % for wildcard searching, ad hoc wildcard filter, report-table wildcard filter, like condition filter , KBA , LOD-SF-ANA-RCT , Report Centre , How To


SAP SuccessFactors HCM Core 1711