SAP Knowledge Base Article - Public

3343333 - Advanced Reporting - Boolean type fields result "t" or f"

Symptom

The boolean fields in Global Job Information domain in Advanced Reporting displays values "t" or "f" instead of "Yes" or "No"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Report Canvas
Advanced Reporting

Reproducing the Issue

1. From Advanced Reporting query, add Boolean field type from Global Job Information table (Example: Is Fulltime Employee?, Eligible for Car Benefit)
2. Preview query or run report.
Result: Result shows "t' or"f" instead of "Yes" or "No"

Cause

Expected Behavior.  Underlying data is 't' and 'f'.  Advanced reporting is returning the actual underlying data.

Resolution

Use other reporting types (Report Table or Report Story) if you need to see the profile value of the boolean field in the report

See Also

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

Keywords

KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Core 2305