OTBI Report showing multiple Parent Position Codes for a record
Summary
Display the current parent position code in the OTBI analysisContent
I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and Compensation - Salary Details Real Time
All of the other fields appear to be displaying correctly EXCEPT for the Parent Position Code. This field is showing multiple records
How do I only display the current parent position code for the record?
I have included the catalog with the OTBI Analysis as well as a screen shot of what the report is showing.
Any help would be appreciated.
I have tried using RCOUNT for the parent Position ID but unfortunately this hasn't helped. I would prefer not to change the report to BIP if at all possible.