SAP Knowledge Base Article - Public

2396182 - List of Filter Values are incomplete in Canvas (ORD) Filter Designer screen

Symptom

In Canvas or Online Report Designer Filter Designer screen, when viewing the list 'select from available value(s) below',  you might encounter that the value does not appear to be available.

Report Values Example.png


 "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 People Analytics
    • SuccessFactors Report Canvs or Online Report Designer

Cause

The number of values displayed in this window is limited.   It might either be due to module or schema specific limits (e.g for LMS it is 200 ), or window and format limitations.

Resolution

Be aware that:

  • decimal points might be displayed by showing four digits after the point
  • a divider for thousands (dot) is used to enhance the display of larger numbers in Employee Central or Compensation
  • decimal points and dividers might be translated differently from EC to reporting than what you expect

Please check the other pages for the value you search and use the search function to look up specific values.

As an alternative or workaround:

You can specify a value manually via 'Enter filter value:' textbox

  1. input or type in the desired value
  2. Click on Select button
  3. The value should appear under Selected values.
  4. Click Ok and test if that will yield results

See Also

2495688 - Report Values are missing in filter of ORD report created on LMS domain
https://me.sap.com/notes/2495688

Keywords

ORD, Online Report Designer, Reporting Values, filter designer screen limit, canvas filters, filter values, filter data , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions