SAP Knowledge Base Article - Public

2653706 - Missing field is showing the ID code in the report and in runtime filter - Online Report Designer


  • Missing field is showing the ID code in ORD
  • The field is showing the ID code in runtime filter
  • There is an extra field running the report online that it is not available in the query
  • The field was deleted but it is still showing in the report


SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Create a report in ORD using Live Data domains (e.g. Employee Profile)
  2. Add some fields to the query (e.g. Customizable Field 1)
  3. Set the Customizable Field 1 in Runtime Filter

  4. Preview the report and check that the result is showing data as expected

  5. Remove the Customizable Field 1 from Data Model and check the report again
  6. In Runtime Filter the field will be available but as ID code

  7. In Preview mode the field will not be available

  8. It is possible to select the filter running the report online

  9. But it will not work

  10. The field will be displayed as ID running the report online but with no data


The report was created using this field in the query and in the Runtime filter. However, the field was removed from the Data Model and the report is not working properly.


As the field was removed and does not exist anymore, you cannot report on it. If you edit report and cannot remove the field, as a workaround recreate the report.


Missing field is showing the ID code in the report and in runtime filter ORD Online Report Designer extra field run the report online not available query delete nonexistent data model , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem


SAP SuccessFactors Workforce Analytics all versions