SAP Knowledge Base Article - Public

2597739 - User Login Data Ad Hoc report showing duplicates

Symptom

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".

Environment

SuccessFactors

Reproducing the Issue

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

Cause

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.

Resolution

Create the report depending on your requirements:

Build a report to show the login events

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
  2. Proceed by selecting "Group By" in the Column section while editing the report
  3. Add an Aggregate Column, select "Total Login" from the dropdown
  4. This way the report will show the actuall total for all events combined

Keywords

User Login Data, Total Login, Adhoc Audit Data , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-PLT-AUDR , Request for Audit Report , How To

Product

SAP SuccessFactors HCM Core 1711