I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User System Usage ' but after selecting the required columns from the both the subject area the table showing in the results tab is coming blank i.e. without any data, just the columns headers are present no data is showing in the tables.

my objective here is to get the mail id of the investigators (person who has been assigned some incidents) in the analysis, from the 'Risk Management Cloud - Advanced Financial Controls Real Time' subject area i am getting the display name in the investigator column but my requirement is to get the mail id of the investigators, I have taken the mail id column from the 'User System Usage' subject area.