This article explains the AND / OR logic behind Ad Hoc reporting (Report - Table) People Scope and Filters.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
SAP SuccessFactors HCM Suite
Reproducing the Issue
Create a new Ad Hoc report or edit an existing one.
With Report Center, this would be Report - Table.
The People pill / People Scope applies 'OR' logic for the filter values chosen within a criterion and applies AND logic between different criteria.
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.
Finally, AND logic is applied between the People Scope and the Filter(s) selected.
Note for Cross domain reports:
The behaviour (AND / OR) of filter groups between domains in a cross domain report will depend on the 'Join Type' chosen under the 'Relationships' pill.
If the Join is set to Left Outer join, the Filter groups between the domains will result in an OR condition between each other.
If the Join type is set to Inner Join, the Filter groups between the domains will result in an AND condition between each other.
Consider the following Example:
A cross domain report started with Employee profile and joined with Performance Management.
If the Join type is set to 'Inner Join', the filter Groups between Employee profile and Performance management domain, will result in an AND combination.
If the Join type is set to 'Left Outer Join', the filter Groups between Employee profile and Performance management domain, will result in an OR combination.
Though it looks like a result of the filters, it is actually because of the way Inner and Left outer Joins work
Ad, Hoc, Report, AND, OR, Logic, Filter, Combination, logic, Table, Cross, domain, not working , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-RCT , Report Centre , How To