This article explains the AND / OR logic behind Ad Hoc reporting (Report - Table) People Scope and Filters.
SAP SuccessFactors Ad Hoc Reporting
SAP SuccessFactors Report Center : Report - Table
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 managent 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 managent 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, Adhoc, AND OR Logic, Filter Combination, Filter logic, Filter not working, Filter Group, How does, Report - Table, Cross domain, Cross-domain, AND, OR, Cross, Filter, Cross, Domain , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-RCT , Report Center , How To