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)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Login to the instance
- Go to Report Center
- Edit the Detailed report (ORD) > Edit Query
- Go to Manage Filters
- 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 Suite all versions