Symptom
- Unable to sort and filter on certain Calculated Columns in Report - Canvas
- We have created a Detailed Reporting Live Data or Advanced Reporting query but when we are trying to filter the report based on calculated column, it is not giving any results
- No data available error
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Login to the instance
- Go to Report Center
- Edit the report > Edit Query
- Go to Manage Filters
- Apply a calculated column as filter
Cause
Limited support for calculated columns of certain data types.
Resolution
Currently the following Calculated Column definitions do not support sort, filter or Runtime filter:
- If a calculated column contains an Adhoc column of type timestamp
- If an AGE function is involved
- If it uses Conditional If/Then/Else statements
- If the source is Learning or LMS domain
- If the Calculated column is based on another calculated column.
In order to filter on fields only use Standard fields in the filter as Calculated columns are not supported.
We request you to submit an enhancement request for the feature.
2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products
Keywords
cannot, filter, calculated, columns, blank, results, date, operators, not, working, greyed, grayed, out , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem
Product
SAP SuccessFactors HXM Suite all versions