SAP Knowledge Base Article - Public

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

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:
tables.png

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

    edit_restrictions.png

  3. Filters applied here, will only impact the selected table
    filter.png

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

Product

SAP SuccessFactors HXM Core all versions