Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBI
I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workforce Performance - Performance Rating Real Time subject areas. However the report generated shows merged and blank cells.
E.g. For the Employees # 90520 and 90521, we see that there are 2 rows from the 3rd column and Salary and Performance Rating columns have 3 rows. Also Salary and Performance Rating values appear in different rows.
Similarly for the Employee # 90522, we see 2 rows. However this time both the rows have Salary value and the bottom one could have been just deleted without any issue.