Symptom
When using the Custom Filter option in Manage Query Filter/Run time filters in Detailed Reporting, the report does not respect the filter values entered with multiple values in one selection.
Environment
- SAP SuccessFactors HCM Suite
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
- Online Report Designer - Detailed Reporting
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
Reproducing the Issue
- While creating a query in Canvas detailed Reporting, click on "Manage Filters"
- Select the Table and the Field to filter
- Select the "Custom Filter" option and type the filter criteria, entered with multiple values in one selection
- Save then preview and see that the filter criteria was not respected in the report
Cause
It is expected and behaviour different with AdHoc Report.
Resolution
When you are typing the filter criteria with multiple values in one selection, it needs to be written exactly one by one value, multiple values are not supported.
You can also use the "Report Values" to select the filter criteria. This option will use the right value stored in the system to filter the report.
See Also
Keywords
detailed reporting, filter criteria, filter, online report designer, report values, custom filters , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem