Joining Workforce Management & Expenses Subject Areas
Summary
Seeking to merge details from Expenses subject area in to Workforce Management reportContent
I have multiple HR-centric reports the draw on the Absences, Compensation, and Workforce Management Subject areas.
I'm seeking to pull in the Default Expense Account attribute from the "Expenses - Employee Expense Overview Real Time" subject area.
I'm having trouble joining these subject areas, as they lack a common dimension. Ideally I could join this on the Assignment Number, this connects the attribute at the right level of granularity, but I'm not successfully joining "Expenses - Employee Expense Overview Real Time"."Employee"."Assignment Number" with "Workforce Management - Assignment Details Real Time"."Worker"."Assignment Number".