Symptom
Boolean field is used in aggregated Table Widget in Story returns Internal Error Message - {"Messages":[{"Type":2,"Number":42014,"Text":"Internal error occurred while processing.","DetailedError":"Caught exception : exception 70000264: invalid datatype: aggr::sum() cannot receive a Boolean type argument\n"}]}
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 Core 2211
Reproducing the Issue
1. Create Story Report including Boolean Field in Data Source
2. Add Aggregated Table Widget in Story Designer and try add boolean field
3. Observe Internal Error Message in UI and detailer error in Network Logs
Cause
There is a known issue where custom boolean fields are added in the query and are coming as "measure" instead of "dimension". This is a known limitation.
Resolution
Workaround:
Create a calculated dimension using the field you require and included in aggregated table widget
Boolean fields use 0 to represent false and 1 to represent True.
Alternatively, Boolean fields show as dimensions when taken from related table, so include the fields from the related table rather than driving table in Story Reports note below example when Job Classification is taken as related table of Job Information.
Keywords
Boolean, Story Report, Internal error, Aggregated, Table Widget, cannot receive a Boolean type argument , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem
Product
Attachments
Pasted image.png |
Snag_605c26.png |