Payroll Costing Setup: Join Position Level Segments with Work Structure Data

Summary:

Having trouble finding a good way to join Position Level costing segments from "Payroll Costing Setup Details Real Time" with relevant columns from "Worker Assignment Real Time" or "Position Real Time".

Content:

I would like to get a working analysis that outputs Position Level costing segments from "Payroll Costing Setup Details Real Time" with columns from other dimensions such as "Worker Assignment Real Time" or "Position Real Time".

The first subject area has very few fields available, with "Costing Level Identifier Details"."Position Name" being the only unique identifier specific to positions in our work structure. Because our Position Names are not always unique I have not yet found a good way to join this with either of the other two subject areas.