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
- Go to Adhoc Reports section.
- Create a new Adhoc Report.
- 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
- Go to ORD/Canvas
- Create a list report of Detailed Reporting
- 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
- Go to Admin Center -> Manage Dashboards
- Click Manage Standard Dashboard and Youcalc Files to create new Tile
- Build Tile -> Select a domain.
- 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, Inactive, Edit , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem
Product
SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions
Attachments
Adhco_FilterValue.docx |