SAP Knowledge Base Article - Public

3049025 - Advanced Filter not saving when using a calculated field on a table level

Symptom

When using an advanced filter to apply a filter on a table level in Story Query design, the change is not saving when using a calculated field but works on non-calculated field

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SuccessFactors HXM Suite
  • People Analytics Report Story

Reproducing the Issue

  1. Create report story.
  2. Drag a table in the query design.
  3. Apply advanced filter in the table level
  4. Use a calculated column field then click on OK button
  5. Then go back to advanced filter (table level), notice the filter applied previously did not save.



Cause

Advanced Filter on calculated column is not possible at the table level. The reason being calculated column can use fields from multiple tables.  



Resolution

Please use Advanced Filter on Story Designer Page Level or Story level  as seen below


Keywords

story filter, advanced filter, calculated column filter, sac filters, pars filters , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , How To

Product

SAP SuccessFactors HXM Core 2105