SAP Knowledge Base Article - Public

2258390 - Live Data Adhoc, Dashboard and ORD report Filter Values

Symptom

In Live Data reports i.e. Ad Hoc, Dashboard and Detailed Reporting (ORD/Canvas), when selecting a filter, inactive values or unwanted values are shown.

Environment

  • SAP Successfactors Workforce Analytics
  • SAP Successfactors HCM Suite
  • Adhoc Reports
  • Detailed Reporting ORD/Canvas
  • Youcalc/Dashboard 2.0 tiles

Reproducing the Issue

Adhoc Reports

  1. Go to Adhoc Reports section.
  2. Create a new Adhoc Report.
  3. Go to Filter section and try to put filter on any column and you can see all values (including from different languages) inserted in the database at some point in time.

Detailed Reporting

  1. Go to ORD/Canvas
  2. Create a list report of Detailed Reporting
  3. Go to Filter section and try to put filter on any column and you can see all values (including from different languages) inserted in the database at some point in time.

Dashboard 2.0 Tiles

  1. Go to Admin Center -> Manage Dashboards
  2. Click Manage Standard Dashboard and Youcalc Files to create new Tile
  3. Build Tile -> Select a domain.
  4. Go to Filter section and try to put filter on any column and you can see all values (including from different languages) inserted in the database at some point in time.

Cause

The column under filter option fetches the entire data from database.

Resolution

  • Filter will fetch all the values based on the values entered for that field in the Data Base and this is an expected behavior.
  • Manually, use filter to select the values required in the report.

Keywords

Analytics, Reporting, Adhoc Reports, Youcalc Tiles, Dashboard 2.0 Tiles ORD Canvas Detailed Reporting , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions

Attachments

Adhco_FilterValue.docx