2613024 - How to Filter only certain tables using Edit Restrictions in Advanced Reporting tables?

This article explains how to apply filters on specific tables only as opposed to applying a filter on the complete report/ query.

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

When a filter is applied to using the 'Manage Query Filter' option, the filter will be applied to the entire report.

Example:

If we want the report to fetch only certain Pay Components, we can add a filter for the same, using the 'Manage Query Filter' option.
This however, would result in excluding all the users who do to have a any Pay Components as well.

If the filter is applied using the 'Edit Restriction' option, it will be applied only to table under concern (Ex: Compensation).
And since the table is connected to the Driving table though Left Joins, the information from the rest of the tables will not be affected by such a filter.
(Left Joins show all records from the object on the left and only records that match from the object on the right.)

1. Navigate to the Objects tab and click the table icon beside the desired table
2. Access the edit restrictions section for that table, by clicking the filter icon
   
   
   
   
3. Filters applied here, will only impact the selected table
   

Note: If the user do not have the permission to see data from a table added to the report and you add a table filter to this table, the report will not run to the affected user and will display message "Role Base Permissions prevents the view of this component". Considering that, always ensure that the user have the required permission to see the table filtered in the report. 

Edit Restrictions, Apply filter on table, selected filter, left outer join filter, Advanced Reporting, REALMS, Report Center, Report - Canvas, Report Canvas, Canvas Report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To