Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real Time

Question

Hi All,

I have created a report using 'Recruiting - Recruiting Real Time' and one of the column Rejection/Withdrawal Reason("Recruiting - Recruiting Events Real Time"."Job Application History - Event Details"."Reason Name") is in 'Recruiting - Recruiting Event Real Time' which I tried to fetch but the result is blank.

Please suggest what could be the reason. Thanking all.

XML Data.txt

SQL Data.txt

Yours Truly,

Robinson Ng

Raghavendra Raghunath-Oracle · Answer

Hi @Robinson Ng can you try this attached logical sql query. If this works, you can append the other columns to the respective queries

Raghu

Recruiting LSQL.txt

Robinson Ng · Answer

Hi @Raghavendra Raghunath-Oracle,

Thanks for the response.

I wish to fetch the candidate's rejection/withdrawal reason that is in "Recruiting - Recruiting Events Real Time" along with columns from "Recruiting - Recruiting Real Time".

Yours truly,

Robinson Ng

Raghavendra Raghunath-Oracle · Answer

Hi @Robinson Ng The common dimension in the recruiting subject area corresponds to the hiring manager and not the candidate. Let me know your reporting requirement, i can suggest a solution/workaround using logical sql

Raghu