Symptom
A custom field of datatype CLOB, used to store text value displays numbers or blanks in the reporting system.
This applies to both Canvas Advanced Reporting and Story databases.
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create a custom field in an MDF object.
- Set its datatype to be CLOB.
- Try using it in an Advanced Reporting report or Story report with the given object
- Check the report output and instead of label (text), the report displays numbers or blanks
Cause
Datatypes CLOB and Attachment are currently not support in Advanced reporting or Story reports.
Resolution
The behvaiour is expected.
The data has to be stored in a text field, to be reported as expected.
Keywords
CLOB, Attachment, Report, Advanced Reporting, missing, story, data, type, object, field, custom, column , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem