SAP Knowledge Base Article - Public

3525183 - Canvas Detailed Reporting does not respect the filter setting when using Custom Filter option with multiple values in one selection

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

Reproducing the Issue

  1. While creating a query in Canvas detailed Reporting, click on "Manage Filters"
  2. Select the Table and the Field to filter
  3. Select the "Custom Filter" option and type the filter criteria, entered with multiple values in one selection
  4. 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

3153674 - Issue while applying a 'Custom' filter in detailed reporting - SAP for Me

Keywords

detailed reporting, filter criteria, filter, online report designer, report values, custom filters , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core 2405