2597739 - User Login Data Ad Hoc report showing duplicates

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

SuccessFactors

Create an Adhoc 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

This 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 your requirements:

Build a report to show total logins by:

1. Create an Adhoc 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) , How To