SAP Knowledge Base Article - Public

2251135 - Errors when running Online Report Designer (ORD) report based on Live data

Symptom

An admin User has created a working report, based on the Live Data via the Online Report Designer, however you are unable to run the report due to some errors and strange behaviour.

Environment

  • SuccessFactors HCM suite
  • Online Report Designer (ORD), Ad Hoc report

Reproducing the Issue

  1. Login to the desired instance. For this example.
  2. Analytics - Analytics
  3. From the Reporting menu select any of the reports under the respective folder.
  4. The Runtime Filters window pops up although you notice that the filter options look like the below:
    • pm#LT_FORM_SUBJECT#USERS_SYS_DEPARTMENT
    • pm#LT_FORM_SUBJECT#USERS_SYS_DIVISION
      runtime filters errors.png
  5. If you try to select a value for the respective filter option no value is available from the Filter Selector.
  6. When you click OK to the Runtime Filters window the below errors may occur:
    • [Role based security prevents the viewing of this component]
    • [Error in rendering table]
    • [Error in rendering List report component]
  7. If you run the report with an admin user the report works fine.

Cause

The affected user does not have access to the respective domain schema.

Resolution

Online Report Designer is a front-end tool which allows users to create reports and queries using a number of different data sources like Ad Hoc, using Live Data.

Live Data gives you access to the Ad hoc data source hence it is mandatory to have Ad Hoc configured and Ad Hoc Domains enabled, to the User role, if you want to be able to run ORD reports, based on live data, correctly.

In this example, the user facing the errors did not have Ad Hoc configured in the assigned role.

Once the User Role included the Create/Run Ad Hoc Report permission and the required Domains the report works.

Note: This can be done via Admin Center - Set User Permissions - Manage Permission Role - Select the desired Role - Report Permission.

Keywords

Runtime Filters errors , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions