SAP Knowledge Base Article - Public

2151607 - MDF fields getting hidden automatically even after enabling from backend

Symptom

In ODS (Advance Reporting), MDF fields getting hidden automatically even after enabling from backend

Environment

SAP Successfactors

Online Report Designer

 

Reproducing the Issue

1. Go to Online Report Designer

2. See if any MDF field is missing in ODS.

 

Cause

Most probably the data type of these fields will be defined as “CLOB” or “ATTACHMENT” under Configure Object Definitions

Resolution

  1. Go to Admin Tools -> Configure Object Definitions -> Search for the MDF Object

screenshot_kba.JPG

2. This is an expected behavior for fields having a specific data type “CLOB” and “ATTACHMENT”. These types of fields will not be reportable in ODS.

3. If the Field data type is CLOB or ATTACHMENT, then the field will not be reportable in ODS.

See Also

  • The concept behind the advanced reporting tool is that it is first and foremost a reporting environment. As part of the design it was decided that information that was stored in a CLOB field or as an attachment was not something that you would generally put in a report. We found that when these sorts of fields were being used in a report it was most likely a data export – not a report.
  • If there is information within a CLOB field that you want to report on then it is ultimately on the BizX module owner to store this information in a better way.
  • As of now there are only 2 MDF fields (CLOB and ATTACHMENT) which are made hidden by default.

Keywords

ORD ODS Advance Reporting MDF CLOB ATTACHMENT , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SuccessFactors Workforce Analytics 1408