Symptom
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.
Environment
SAP SuccessFactors Online Report Designer - Advanced Reporting
SAP SuccessFactors Report Center > Report - Cavas > Advanced Reporting
Resolution
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.)
- Navigate to the Objects tab and click the table icon beside the desired table
- Access the edit restrictions section for that table, by clicking the filter icon
- Filters applied here, will only impact the selected table
Keywords
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) , LOD-SF-WFA-REL , Realms User Tool , How To