SAP Knowledge Base Article - Public

3512488 - Conditions is different under 'Set Conditions for Advanced Filter' between data source Query Designer and Page Filter settings - People Analytics Story Report

Symptom

Story Report support to add 'Set Conditions for Advanced Filter'(Advanced Filter) under both Data Source Query Designer page and Page Filter settings.

Some of Conditions is support under "Query Designer - Advanced Filter setting" but not support under "Page Filter - Advanced Filters".

Advanced filtering allows you to filter multiple data fields by defining a set of logical conditions.

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
  • Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD, Story Report)
  • People Analytics - Story Report

Reproducing the Issue

  1. Add an Advanced Filter under data source Query Designer and Page Filter settings.
  2. Select an operator to filter data from the selected column.
  3. From data source Query Designer, you can apply "Equal to", "Except", "Is null", or "Is not null" as the operator.
  4. From Page Filter - Advanced Filters, you can only apply "Equal to" and  "Does not equal"

Cause

Different behaviour settings of Query Designer and Page Filter settings.

Resolution

For the Page Filter - Advanced Filters, there's only "Equal to" and "Does not equal" being supported.

For Query Designer - Advanced Filters, 

  • For all columns, you can apply Equal to, Except, Is null, or Is not null as the operator.
  • For String type columns, you can additionally apply Like.
  • For Numeric, Integer, Decimal, Date and Datetime types of columns, you can additionally apply Greater than, Greater than or equal to, Less than, Less than or equal to, or Between.

See Also

Applying an Advanced Filter | SAP Help Portal

Keywords

Conditions, Advanced Filter, Equal to, Does not equal , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To

Product

SAP SuccessFactors HCM Core 2405