You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Report showing multiple Parent Position Codes for a record

edited Mar 24, 2021 2:25PM in Reporting and Analytics for HCM 8 comments

Summary

Display the current parent position code in the OTBI analysis

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!