SAP Knowledge Base Article - Public

2258390 - Adhoc Report Filter Values

Symptom

While creating an Ad-hoc report or Dashboard 2.0 custom tile, when user selects any column from a particular view group and tries to filter on the column name, all values related to the data type are displayed.

Please refer the attachment for better understanding of the issue.

Environment

  • SAP Successfactors
  • Adhoc Reports
  • Youcalc/Dashboard 2.0 tiles

Reproducing the Issue

For 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(from different language) if all these values are entered for the filed in the database.

For 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(from different language) if all these values are entered for the filed in the database.

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 , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , Dashboard and YouCalc , Problem

Product

SAP SuccessFactors Workforce Analytics 1511 ; SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1408 ; SuccessFactors Workforce Analytics 1508

Attachments

Adhco_FilterValue.docx