Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Provide Link to Candidate Job Submission in OBIEE Report

Received Response
41
Views
4
Comments

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? 

Answers

  • Prudence K
    Prudence K Rank 5 - Community Champion

    Hi - there is a support doc that provides information on how to do this: 2063826.1.  Do you have access to pull this document?

    The link for the Submission is going to be: https://%CompanyName%.taleo.net/enterprise/publicurl/viewApplication?applicationNumber={1}

    Here were the instructions provided:

    1. Access Oracle Business Intelligence as BI Author Developer
    2. Navigate to the analysis and select the link to Edit
    3. Select the Criteria tab
    4. If not already present, add "Candidate Identifier" or "Req. Identifier" or "Submission Identifier (RCAPPLICATIONNO)" to the Selected Columns section. If setting up link to submission then edit the "Submission Identifier (RCAPPLICATIONNO)" column formula and replace it with CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR)
    5. Drop-down to the right of the field and select Column Properties
    6. Select the Interaction tab
    7. Under the Value section, drop-down on Primary Interaction and select Action Links
    8. Select the green plus sign to Add Action Link
    9. Enter the name for the action next to Link Text
    10. Next to Action, select the green wheel with the orange star to Create New Action
    11. Select the option Navigate to a Web Page
    12. In the Create New Action window, next to URL, enter the appropriate URL
      • Remember: replace %CompanyName% with your zone name and do not include the {1} at the end
    13. Select the button to Define Parameters
      • Note the URL is now appended with: @{1}
    14. Leave the default values for Name and Prompt as is; under Value, drop-down to select Column Value
    15. Drop-down to select either "Candidate Identification"."Candidate Identifier" or "Requisition Identification"."Req. Identifier" or CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR) column accordingly
    16. Check the box for Hidden
    17. Un-check the box for Optional
    18. Select the Options...button in the bottom left corner
    19. Check the box for Open in New Window
    20. Select OK all the way back to the Criteria tab
    21. Select the Results tab to click on any value within the column; users should now be linked to the record in Recruiting
  • Chris Shaver - HEB
    Chris Shaver - HEB Rank 1 - Community Starter

    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.

  • Prudence K
    Prudence K Rank 5 - Community Champion

    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.

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

      'https://%CompanyName%.taleo.net/enterprise/publicurl/viewApplication?applicationNumber='||CAST("Submission General Info"."Submission Identifier (RCAPPLICATIONNO)" AS CHAR)
       
    6. Drop-down to the right of the field and select Column Properties
    7. Select the Data Format tab
    8. Check the box for Override Default Data Format
    9. Under Treat Text As, drop-down to select HyperText link
    10. Select OK
    11. 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
    Chris Shaver - HEB Rank 1 - Community Starter

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