SAP Knowledge Base Article - Public

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

Symptom

  • 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

Environment

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
    runtime.png

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

  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
    runtime_error.png

  7. In Preview mode the field will not be available
    preview_nocolumn.png

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

  9. But it will not work
    browser_error.png

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

Cause

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.

Resolution

As the field was removed and does not exist anymore, you cannot report on it.

However, as the column is not available editing the query, it is not possible to remove it, even though it is still attached to the report component.

The solution in this case is to recreate the whole report in ORD.

Keywords

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, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions