2352701 - Add Boolean fields to the field types offered in ORD / Analytics / Report-Canvas Calculated Columns

Symptom

Few fields which are of "Boolean" data type are not available in the "Calculated Column page".

Users will not be able to use such fields to create calculated column.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

Login to the Instance
Navigate to Report Center
Create a Canvas Report
Create a calculated column
You will find that the boolean fields are not showing up.

Example: Position MDF Object.
Vacant field would most likely be a boolean field

Cause

Calculated Columns currently recognize only three Data types currently ( i.e. Number, String, Date) .

Resolution

We currently do not support fields of Boolean datatype in calculated column of Advanced Reporting. This is as per the current system design.

Please use Story reporting type, fields of all data types are available in calculated columns.

Keywords

Calculated Columns, Boolean fields, data type as boolean, Boolean, realms, advanced reporting, Report-Canvas, Report Canvas, Detailed Reporting , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

Product

SAP SuccessFactors HCM Suite all versions