General OBIEE

Get Involved. Join the Conversation.

Topic

    Christopher Shaver
    Provide Link to Candidate Job Submission in OBIEE ReportAnswered
    Topic posted April 18, 2018 by Christopher ShaverSilver Trophy: 7,500+ Points, tagged Analyses, Customizing Reports, OBIEE Answers, Report Layouts, Report Output, Reports, Sample Reports, Setup, Setup/Administration, Taleo Enterprise 
    223 Views, 4 Comments
    Title:
    Provide Link to Candidate Job Submission in OBIEE Report
    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? 

    Best Comment

    Prudence Kruchten

    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

    Comment

     

    • Prudence Kruchten

      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
    • Christopher Shaver

      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 Kruchten

        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
    • Christopher Shaver

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