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

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.

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.

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

Keywords

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

Product

SAP SuccessFactors HCM Suite all versions