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
- Go to Calculated Column and create one
- Expand the option for Global Job Information and the boolean field configured in BizX is available under the section of "Text"
- 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.
Keywords
calculated column, string, text, number, date, boolean, MDF, MDF Object , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To