How to display the recruiting candidate's department name in OTBI

Summary:

Content (required):

I have a candidate who's department in the job offer is different from the one in the requisition. Using OTBI, is it possible to display the Department Name associated with the Department ID found in the subject area Recruiting Real Time --> Job Offer --> Job Offer - Assignment Details?

In this subject area I find the Department Name in Job Requisition-->Department. For some candidates the department in Job Offer differs from those in Requisitions

Thank you

Version (include the version you are using, if applicable):

Oracle Business Intelligence 11.1.1.9

Code Snippet (add any code snippets that support your topic, if applicable):