SAP Knowledge Base Article - Public

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

  1. Login to the Instance
  2. Navigate to Report Center
  3. Create a Canvas Report
  4. Create a calculated column
  5. 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.

See Also

2877303 - Quick Guide to Enable People Analytics Report Story - SAP ONE Support Launchpad

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) , Problem

Product

SAP SuccessFactors HXM Suite all versions