SAP Knowledge Base Article - Public

2939538 - Calculated Column - Boolean Fields from Job Information vs Boolean Fields from MDF Objects

Symptom

Boolean fields from Job Information is available as an option in Calculated Column in Advance Reporting while boolean field from MDFs objects are not available.

Environment

  • SAP SuccessFactors HCM Suite
  • Advance Reporting

Reproducing the Issue

  1. Go to Calculated Column and create one
  2. Expand the option for Global Job Information and the boolean field configured in BizX is available under the section of "Text"
  3. Expand the option for any MDF object (for example Position Table) and the boolean field configured in BizX is not found in any section (Number, Date, Text)

Cause

The reason why the boolean field configured in Job Information is available in Calculated Column is because the mappings of EC from BizX to WFA are maintained in the template. Therefore for these fields even though is Boolean in BizX, it is defined as String in WFA. And that is why these fields are available under the section of "Text" in Calculated Column.

This scenario is not the same with MDF objects. The mapping of these objects from BizX to WFA is not maintained in a template and that is why their data type in BizX is the same as their data type in WFA.

Resolution

As per current design of the Calculated Column, it only supports Number, String and Date data type.

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

Keywords

calculated column, string, text, number, date, boolean, MDF, MDF Object , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Core 2005