Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 287 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real Time
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.
Yours Truly,
Robinson Ng
Answers
-
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
0 -
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
0 -
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
0
