SAP Knowledge Base Article - Public

2349672 - Unable to sort and filter on certain Calculated Columns in Report - Canvas

Symptom

  • Currently some functions are not supported on Calculated columns in Canvas reporting (Detailed reporting).

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)
      • Detailed Reporting (ORD)

Reproducing the Issue

  1. Login to the instance
  2. Go to Report Center
  3. Edit the Detailed report (ORD) > Edit Query
  4. Go to Manage Filters
  5. Apply a calculated column as filter

Cause

Limited support for calculated columns of certain data types.

Resolution

Currently some functions are not supported on Calculated columns, for any Calculated column under Query level Filter Designer "Report Values" Tab can't be selected, we can use only Custom Filter and Field Comparison.

  • If a calculated column contains an Adhoc column of type timestamp then it doesn't appear under Runtime filter
  • If an AGE function is involved then it doesn't appear under Runtime filter
  • If it uses Conditional If/Then/Else statements then this appears under Runtime Filter.
  • If the Calculated column is based on another calculated column then it doesn't appear under Runtime filter

Keywords

cannot, filter, calculated, columns, blank, results, date, operators, not, working, greyed, grayed, out, Detailed, Reporting, ORD , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM all versions