SAP Knowledge Base Article - Public

3212363 - How does the 'Like' rule work in filters for Tables/Tiles/Canvas/Story reports in SuccessFactors?

Symptom

  • How does the 'Like' rule work in filters for Tables/Tiles/Canvas/Story?
  • How is the 'Like' rule different than 'Equal to' rule?

Environment

  • SAP SuccessFactors HXM Suite
  • Table/Ad-hoc
  • Tiles/Dashboard
  • Canvas/Detailed/Advanced
  • Story/People Analytics

Resolution

Table/Tiles

Like rule works exactly like 'Equal to' rule, showing only the records that exactly match the value. One difference it that we can also add the '%' symbol to the prefix or suffix of the value to fetch all the matching entries.

As an example:

Column Name: Title

Results:
Test2020
Test2021
Test2022
Example2020
Example2021
Example2022

Filter: Title Like Test

Results:
Null

Filter: Title Like Test2020

Results:
Test2020

Filter: Title Like Test%

Results:
Test2020
Test2021
Test2022

Filter: Title Like %2020

Results:
Test2020
Example2020

Filter: Title Like %ample%

Results:
Example2020
Example2021
Example2022

Canvas

Like rule does not need any special symbols to fetch all the matching entries. It applies the formula automatically.

As an example:

Column Name: Title

Results:
Test2020
Test2021
Test2022
Example2020
Example2021
Example2022

Filter: Title Like Test

Results:
Test2020
Test2021
Test2022

Story

Similar behaviour to Table report, except the symbol used is either '*' or '?'. We also get the same message when using the Like rule:

Keywords

Table, Ad-hoc, Tiles, Dashboard, Canvas, Detailed, Advanced, Story, People Analytics, Like, Rule, Equal To, Symbols, %, *, ? , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Bug Filed

Product

SAP SuccessFactors HXM Core all versions ; SAP SuccessFactors HXM Suite all versions