2479254 - Runtime filter not working for report with multiple REALMS / Advanced Reporting components.

SAP Knowledge Base Article - Public

2479254 - Runtime filter not working for report with multiple REALMS / Advanced Reporting components.

Symptom

Selected runtime filter apply only to the first component in a report page with multiple REALMS / Advanced Reporting components.

Environment

SuccessFactors Advanced Reporting / REALMS

Reproducing the Issue

  1. Login to the instance and navigate to Analytics > Report Designer.
  2. Create a new report and add a list report component.
  3. Edit the component and create a new Advanced Reporting Query or use an existing one.
  4. Edit the query and add a runtime filter for one of the fields (example: UserID).
  5. Save changed and exit the editor screen.
  6. Navigate back to the report designer screen.
  7. Copy the component a couple of more times.
    or
    Create a couple of other list report components, add advanced reporting queries and add runtime filters for the same field (UserID) in all the components.
  8. Exit the Report designer and run (preview) the report.
  9. At the run time filter screen, apply a filter for the column we had added in step 4 .
  10. Only the first component respects the applied runtime filter and the components don’t.

Cause

This is expected behaviour.
For REALMS , runtime filter will only consider (arbitrary) first component found in the page.
The reason why it can only work with one query is, in Report Values tab (of filter designer), realms filter will show all possible values in the query.

Resolution

The closest solution is to break the page down, creating one report page per component.

Keywords

REALMS / Advanced Reporting
Runtime filter , KBA , LOD-SF-WFA-REL , Realms User Tool , Problem

Product

SAP SuccessFactors HCM Core 1702