SAP Knowledge Base Article - Public

3339267 - Canvas report runtime filters on Calculated Column doesn't take Null as filter value

Symptom

Canvas report gives the browser error if the filter value of Runtime filter is set as Null.

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 HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Advanced Reporting (ODS)

Reproducing the Issue

1. Create a canvas report calculated column like below and add a Runtime filter.



2. Run the report and select Null value for the runtime filter value.

3. The report will give below browser error.

Resolution

This is an expected behavior.
As per current functionality, Runtime filter will not take Null as value.

Raise an enhancement request to enable this feature in the report.
2090228 - How to submit enhancement ideas for SAP SuccessFactors Products





Keywords

calculated, column, runtime, filter, null, value, canvas, report, browser, error , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite 2305

Attachments

Pasted image.png