SAP Knowledge Base Article - Public

2386877 - Duplicate Rows are Displayed in Dashboards Chart Drill Down (Analytics Tile Builder)

Symptom

Multiple rows for the same record are returned in the drill-down information of a custom Dashboard tile.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

Cause

The report returns all matches according to query definition but the dashboard tile does not exclude the duplicate records.

Resolution

Use the Enable Distinct feature in the Drill Down Tab of the Tile Builder.  This will show only the unique records.

Admin Center > Manage Dashboards > Manage Standard Dashboards and YouCalc Files > Select and Edit Tile to get to Analytics Tile Builder > Drill Down

Enable Distinct in Dashbaords Tile Drill Down.jpg

Keywords

Drill Down, Dashboards, Enable Distinct, duplicate rows returned, display only unique records, Tile Builder, custom tile , KBA , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem

Product

SAP SuccessFactors HXM Suite all versions