SAP Knowledge Base Article - Public

2444627 - Custom CLOB field from an MDF displays numbers or blanks when using Story or Canvas Advanced Reporting queries

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

  1. Create a custom field in an MDF object.
  2. Set its datatype to be CLOB.
  3. Try using it in an Advanced Reporting report or Story report with the given object
  4. 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 , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM suite all versions