SAP Knowledge Base Article - Public

2261705 - Login data report only generate single entry not in a total number

Symptom

When create single domain report "login data" report by using columns "Login YTD" and "Login this month" and "Login this month".

 

Even a user has multiple login history, data has been generated not in a total number but in separate lines.

 

 

The result will be displayed as below:

 

User Id Last Name First name First Login Last login Login YTD Login this month Login this month
UserA A User 9/24/2015 9/24/2015 1 1 1
UserA A User 9/8/2015 9/8/2015 1 1 1

Even this user has mutiple entries in a month, it will only be showed in single entry as "1" not in a total number.

Environment

Bizx Core B1508

Reproducing the Issue

1. Go to “Reports” > Ad hoc reports> login data

2. Add Columns “Logins YTD” &”Login This Month” &”Total Logins”

3. Click Preview

> Login YTD and Login this month and Total login are all “1”.

> Last login and first login is the same day.

 

Cause

In Login adhoc report data is displayed as it s fetched from DB. You are getting single entries as their is unique data for first and last login for each day.

 

Hence this is system's expected behavior to fetch the data each day and generate data in single entry.

 

 

Resolution

You can put count on total logins columns and select username column. You can put filter on First and Last login depending on date range you want with greater than or less than operators. You will get same data. In adhoc report we need to do additional operations on the data to get desired output.

Keywords

login data, output,single data,Total Logins, Count of login , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HCM Core all versions