SAP Knowledge Base Article - Public

2798281 - Unexpected values showing as filter criteria in the Runtime filters - Advanced Reporting

Symptom

  • Unexpected/wrong values are showing up in the runtime filter criteria in Advanced Reporting; 
  • Is it possible to filter on Calculated Column fields in Manage Query Filters? 

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 HCM Suite
  • Canvas reports

Reproducing the Issue

  1. Go to Home > Reporting;
  2. Select the report that is showing the unexpected filter values and run the report;
  3. When the Filter Summary pop-up shows up, click on "Select values to filter" option on the right side of the field available to select the filter criteria; 
  4. Select the field > Select the Operator > Click on "Report Values";
  5. Notice that some available values are not stored in the system.

    filters 1.png

How are these values are available to be selected if they are not stored in the system?

Cause

These values are showing in the filter values on the Runtime Filters because they were created by calculated columns that were defined as Runtime Filters.

In this example, the calculated column called 'test1' was created. Inside 'test1', the values shown on the screenshot above were created as condition results inside 'test1', as you can see below:

calculated column.png

Resolution

If you do not want to see these values, you have three options:

  1. Remove the unexpected values from the calculated column by changing the condition results;
  2. Remove the calculated column from the runtime filters;
  3. Hide the calculated column from the query.

Please note: it is only possible to filter on calculated column's results when using it in Runtime Filters. It is not possible to use calculated column's results on Manage Query Filters.

See Also

 2349672 - Calculated Columns don't work under Manage Filters

Keywords

Advanced Reporting, filter values, advanced reporting query, filter, unexpected values showing as filter criteria in a canvas report query, wrong values in filter options , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM Suite all versions