3310147 - Boolean field used in aggregated Table Widget in Story returns Internal Error Message

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.

SAP SuccessFactors HXM Suite Core 2211

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

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.

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.

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