SAP Knowledge Base Article - Public

2673770 - How do filter combinations in Ad Hoc / Report - Table reports work (AND / OR logic)?

Symptom

This article explains the AND / OR logic behind Ad Hoc reporting (Report - Table) People Scope and Filters.

Environment

SuccessFactors Ad Hoc Reporting

Reproducing the Issue

Create a new Ad Hoc report or edit an existing one.
With Report Center, this would be Report - Table.

Resolution

People Scope:

The People pill / People Scope applies 'OR' logic for the filter values chosen within a criterion and applies AND logic between different criteria.

PPL_Scope.jpg

Filters:

Options selected for a specific field - OR logic between each other.
Different fields selected within the same Filter Group - AND logic between each other
Different Filter Groups - OR logic between each other.

Example 1:

Filter_Group.png


Example 2:

Ex_1.png

Example 3:

Ex_2.png

Finally, AND logic is applied between the People Scope and the Filter(s) selected.

Keywords

Ad Hoc Report
Adhoc
AND OR Logic
Filter Combination
Filter logic
Filter not working , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-RCT , Report Center , How To

Product

SAP SuccessFactors HCM Core all versions