Provide Link to Candidate Job Submission in OBIEE Report

Question

Summary

I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool.

Content

Is there a way to include a link to a candidate's job submission in the OBIEE reporting tool?

Chris Shaver - HEB · Answer

PRUDENCE!!!!!!  You are my hero for the day, even the week!  I truly appreciate the assistance today!

Prudence K · Answer

OH OK, that's slightly different then!  While the option below works for clicking the link and pushing people into the Recruiting tool, it does it within the same window (could not find a way to have it open in a new window) and removes people from reporting.  However, if you are only looking for the link in the output, then that won't matter so much.

* Access Oracle Business Intelligence as BI Author Developer
* Navigate to the analysis and select the link to Edit
* Select the Criteria tab
* If not already present, add "Submission Identifier (RCAPPLICATIONNO)" to the Selected Columns section.
* Edit Column Formula with this:

'https://%CompanyName%.taleo.net/enterprise/publicurl/viewApplication?applicationNumber='||CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR)

* Drop-down to the right of the field and select Column Properties
* Select the Data Format tab
* Check the box for Override Default Data Format
* Under Treat Text As, drop-down to select HyperText link
* Select OK
* Select the Results tab to click on any value within the column; users should now be linked to the record in Recruiting and the link will transmit to Excel and PDF outputs

Chris Shaver - HEB · Answer

Prudence!  Thank you so much for those detailed instructions.  Do you have anyway to make the links appear on the exported reports (either PDF or Excel)?  Right now, while in OBIEE, I can see and access the candidate job submissions.  However, when I export the data to a PDF or to Excel, the link disappears.