Symptom
Adhoc report Sub domain Person and Employment info (as of date) Shows Multiple Records When Including Pay Component or Compensation Information data
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
Employee Central-Adhoc Report
Reproducing the Issue
View test user Compensation Portlet
- Go to test user Compensation Portlet
- Result: Test User has 2 Pay range records in compensation Information on 01/02/2019 and 01/05/2019
Run Adhoc Report
- Go to Adhoc report
- Select Sub-Domain Person and Employment (As of Date)
- Click column Compensation Information
- select Pay Range
- Run
- Result: the Report shows 2 Pay range records in compensation Information on 01/02/2019 and 01/05/2019
Cause
This is expected Behavior
Resolution
This is expected Behavior, you could end up with duplicate rows in the report if you include Pay Component or Compensation Information data (if employees tend to have more than one)
Employee data as of a given date (today by default unless specified)
- Be mindful of the amount of Column Sets (JOINS) you include in 1 report - for example you could end up with duplicate rows in the report if you include Pay Component or Compensation Information data (if employees tend to have more than one)
- Make sure to use Filters to limit the size/scope of the report - such as filtering on a particular Legal Entity, or Country.
- This report respects Cell Level Permissions
Keywords
Person and Employment info (as of date), multiple records, Pay Component, Compensation Information data,Adhoc report , Reporting, Legal Entity, Country , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem