SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP SuccessFactors Workforce Analytics

Resolution

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.

Keywords

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

Product

SAP SuccessFactors HCM Core 1711