SAP Knowledge Base Article - Public

2531743 - Adhoc Report returns more results than expected - using runtime filter

Symptom

When using runtime filters with an adhoc report the report returns more values than expected

Environment

Successfactors / Adhoc Reports

Reproducing the Issue

  1. Create an adhoc report
  2. Add filters in the adhoc report
  3. Add a 2nd Filter Group
  4. Add additional filters in the 2nd Filter Group
  5. Enable the filters for user prompt to allow selection of the filters at runtime
  6. Run the report and select filters - for example for a region
  7. Result might show results in addition to the selected region.

Cause

When you use more than one Filter Group the syntax of the filter changes.

Filters within one Filter Group are based on an AND function - that means all criteria have to be met.

Between two different Filter Groups there is an OR function - that means the report will show all results which are true for the selection in Filter Group 1 OR Filter Group 2

Resolution

If you get more results than expected please ensure you make use of one single Filter Group.

Keywords

Adhoc Report Result Scope Filter Filter Group , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors HCM Core 1602 ; SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Core 1711 ; SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1411 ; SuccessFactors HCM Core 1502 ; SuccessFactors HCM Core 1505 ; SuccessFactors HCM Core 1508