Duplicated records in Story report for Compensation

[ishaqyousuf]

Hello community members,

I am create a story report where Job Info is a leading table. Requirement is to bring Current year (Jan 1 to Dec 31 2023) data for job info and compensation and calculate Annual Salary.

Everything is working except that my system is giving multiple and duplicated records. So if Job info has 4 records and compensation has 3 records then system shows 12 records (4 x 3) in a way that for each job info, it bring 3 compensation records.

I have tried Aggregated columns but it sums up the amount which is in Compensation portlet for Basic salary

For Job Info Effective start date 4^th Dec 2023, there are 4 records pulled from comp info 4^th Dec, 11^th Dec, 18^th Dec and 25^th

Dec.

Again for job Info start date 11^th Dec 2023, 4^th Dec 2023, there are 4 records pulled from comp info 4^th Dec, 11^th Dec, 18^th Dec and 25^th

Dec.

[ishaqyousuf]

Just an addition in my question is that if I use 'Table structure' as Non Aggregated then 25 records are visible as in Employee profile, 5 records exist for Job Info and 5 for compensation info so system shows 5 x 5 = 25 records

When I use ''Aggregated' in Table , system shows 1 record but it sums the salary amount mentioned in each record of compensation as shared in the SS that in the backend, system considered 25 records (highlighted in "Count" column to calculate the AS amount

[Neeraj_Jain]

Hello ishaq.yousuf,

Please refer below SAP Note.

https://userapps.support.sap.com/sap/support/knowledge/en/3171154

3171154 - Multiple records appearing when creating a Compensation Planning Story

Regards,

Neeraj Jain

[ishaqyousuf]

Hi Neeraj,

The KBA is about Compensation Planning schema. In my case, data exits in compensation information / pay component recurring.

[MikeC]

Hi. Why can't I access this answer please? I'm having the same issues but can't see the answer. I have a sap communities login but it doesn't work to see this answer. Is there another account I need? Thanks