2597739 - User Login Data Table Report is showing duplicates

Retrieving First Login, Last Login and Access Date in Table Report from the "User Login" domain shows the same values in each line. Also the Total Login data comes up as single lines showing "1".

SAP SuccessFactors HCM Suite

Create a Table Report

Without Report centre:

1. Click on "Home" -> "Reporting"
2. Select the "Report" tab
3. Create new Report
4. Select "User Login" domain
5. Select the Columns "User ID" or "User Name", as well as "First Login", "Last Login", "Access Date" and "Total Logins"
6. Click "Preview" or export the report

With Report Centre:

1. Click on "Home" -> "Reporting"
2. Click "New Report"
3. Select "Table" and click "Ok"
4. Select "User Login" domain
5. Select the Columns "User ID" or "User Name", as well as "First Login", "Last Login", "Access Date" and "Total Logins"
6. Click "Preview" or export the report

Issue is caused by the way the user login domain is configured. For each instance of a login, the system is saving First Login, Last Login and Access Date. This will translate in the report to create a line for each login event.

Create the report depending on the requirements:

Build a report to show total logins by:

1. Create an Table report as above, but select only User ID or User Name and Total Login. (Remove rows that have timestamp)
2. Proceed by selecting "Group By" in the Column section while editing the report
3. Add an Aggregate Column >  select "Count(Distinct(Total Logins))" from the dropdown
4. This way the report will show the actual total for all events combined and will not count duplicate or repeating rows

User Login Data, Total Login, Adhoc Audit Data, unique logins , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-PLT-AUDR , Request Audit Report (Not Change Audit) , Problem