2396711 - How do filter combinations in Ad Hoc reports behave (AND / OR logic)?

SAP Knowledge Base Article - Public

2396711 - How do filter combinations in Ad Hoc reports behave (AND / OR logic)?

Symptom

This article explains the AND / OR logic behind Ad Hoc reporting People Scope and Filters.

Environment

SuccessFactors Ad Hoc Reporting

Reproducing the Issue

Create a new Ad Hoc report or edit an existing one.

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
AND OR Logic
Filter Combination , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Core all versions