General OBIEE

Get Involved. Join the Conversation.

Posts

  • Phil Eaton
    Pulling multiple candidate Q&A answers into single column5.0
    Topic posted June 21, 2019 by Phil Eaton, tagged OBIEE Answers, Reports, Taleo Enterprise 
    Title:
    Pulling multiple candidate Q&A answers into single column
    Summary:
    Advice on how to combine multiple candidate answers into single column
    Content:

    We are currently running a campaign where a requisition has been duplicated 20 times. We have 6 'ace' pre screening questions that Taleo decided to duplicate each time the requisition was duplicated.

    Therefore we have 20 separate question codes for each question. From a reporting point of view, the business want candidates from all 20 reqs on a report complete with answers to said 'ace' questions in 6 columns.

    I need a solution to pull 20 separate answers into a single column. I will then repeat the process for each of the 6 questions.

    Can anyone help?

    Thanks

    Version:
    OBIEE 11.1.1.9.0
  • Christopher Shaver
    Provide Link to Candidate Job Submission in OBIEE ReportAnswered4
    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 
    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? 

  • Ramesh Nakka
    Pipleline Time In Process - Detail & Metrics Performance...
    Topic posted March 28, 2018 by Ramesh NakkaBronze Crown: 15,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, Reports, SQL, Taleo Enterprise 
    Title:
    Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQL
    Summary:
    Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQL
    Content:

    Hi All,

    We have a dashboard -Pipeline Time In Process which consists of both Detail and Metrics tab.

    We have created this Dashboard by using advanced SQL as it consists of backlink  logic (Sourcing and Hiring Requisitions are linked to get the complete history).

    The issue is that it is giving very poor performance. Just running for 5 Days globally for all GU's.

    Can anybody is using similar kind of Pipeline Time In Process Dashboard  with good performance with it, without using advanced SQL.

    Any thoughts or comments are highly appreciated on for improving the performance

    Metric Report should look like below.

     

    Geographic Unit Country New HM Review Sponsor Review First Assessment Second Assessment Third Assessment Fourth Assessment Fifth Assessment Business Case Offer Hire Digital Assessment
    ANZ Australia 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.00 6.00 0.00  
    ANZ New Zealand 0.00 0.00   0.00 0.00              
    ANZ Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.00 6.00 0.00  
    ASEAN Indonesia 0.00 0.00   0.00 0.00         6.00 0.00 0.00
    ASEAN Malaysia 0.00 0.00   0.00 8.00 0.00 24.00 0.00   3.00 0.00 0.00
    ASEAN Singapore 0.00 0.00   0.00 1.00 0.00 21.00     0.00 0.00 0.00
    ASEAN Thailand 0.00 0.00   0.00 0.00 0.00       29.00 0.00 0.00
    ASEAN Total 0.00 0.00   0.00 1.00 0.00 24.00 0.00   6.00 0.00 0.00
    ASGR Austria 0.00 0.00   0.00 6.00 0.00 23.00     4.00 0.00  
    ASGR Germany 0.00 0.00   0.00 0.00 0.00       48.00 0.00  
    ASGR Switzerland 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 77.00 0.00  
    ASGR Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 77.00 0.00  
    Africa South Africa 0.00 0.00   0.00 0.00 0.00       0.00 0.00  
    Africa Total 0.00 0.00   0.00 0.00 0.00       0.00 0.00  
    Canada Canada 0.00 0.00   1.00 0.00 0.00 0.00     5.00 0.00  
    Canada Total 0.00 0.00   1.00 0.00 0.00 0.00     5.00 0.00  

     

    Regards,

    Ramesh

  • Iqra Khan
    Candidate Drop off Report2
    Topic posted October 31, 2017 by Iqra KhanSilver Medal: 2,000+ Points, tagged Analyses, Customizing Reports, OBI Answers, OBIEE Answers, Reports, Sample Reports, Taleo Enterprise 
    Title:
    Candidate Drop off Report
    Summary:
    a report that gives details on when a candidate drops off at an application and doesn't complete/submit
    Content:

    We have been working on building a candidate drop off report for some time now. We need to be able to identify the number of profile submissions and the number of candidates who dropped off during the application process and did not complete their application. Does anyone have something like this they are using right now? If so, did oracle build this report for you? How was it customized to fit your application? We are seeing a high number of applications in draft and need a way to capture these candidates and see at what point they are dropping off.

  • Natalie Andrek
    Remove duplicate values in OBIEE4
    Topic posted March 24, 2017 by Natalie AndrekBlue Ribbon: 750+ Points, tagged Analyses, Customizing Layout, OBI Answers, OBIEE Answers, Report Layouts, Reports, Setup, SQL, Taleo Enterprise 
    Title:
    Remove duplicate values in OBIEE
    Content:

    Hi All,

    Is it possible to remove duplicate values in OBIEE?

    In my report, columns A and B have unique values per line for an employee, however, column G is all the same value and it repeats itself to match the same number of lines of column A & B. The screenshot can probably demonstrate this a lot clearer than I'm describing it :).

    Is it possible to remove all but the bottom value in column G?

    Thank you in advance for your help!

    Natalie Flanagan

    Image:
  • Ellen Manthei
    Issue with Percentage in Pivot Table
    Topic posted February 23, 2017 by Ellen MantheiSilver Trophy: 7,500+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, Report Layouts, Report Output, Reports, Taleo Enterprise 
    Title:
    Issue with Percentage in Pivot Table
    Summary:
    Issue with Summarizing Percentages in Pivot Tables
    Content:

    I have a calculation for the fill rate based upon hired vs target.  This is working fine in the details, but when I summarize it in a pivot table the numbers are flat out wrong.  Ideas on how to fix?

    formula:  ((("Candidate Counts"."# Submissions Currently Hired")*1.0)/((CAST("Requisition Flex Fields"."UDF25" AS INTEGER))*1.0))*100

    This formula works correctly in the details table, but the pivot table isn't calculating correctly.

    Images attached

     

    Document:
  • Shikha Patel
    OBI Self-Service Reporting (i.e. OBI Content View...1
    Topic posted October 14, 2016 by Shikha PatelGreen Ribbon: 100+ Points, tagged OBI Answers, OBIEE Answers, Report Delivery, Report Output, Reports, Setup, Setup/Administration, Taleo Enterprise 
    Title:
    OBI Self-Service Reporting (i.e. OBI Content View Only)
    Summary:
    Have any customers been successful with launching OBI Self-Service?
    Content:

    Oracle told us they do not have folder security permissions and Read-Only capability for reports properly working for the OBI Content View Only user group until 15B. Just wondering if any other customers are experiencing the same problem for earlier releases? Has anyone been successful in launching self service Taleo reporting with OBI for releases earlier than 15B?

  • Alexis Rivers
    Days between Step/Status1
    Topic posted July 23, 2016 by Alexis RiversBronze Medal: 1,250+ Points, tagged Analyses, OBI Answers, OBIEE Answers, Report Layouts, Report Output, Reports, Scheduling or Agents, Setup, SQL, Taleo Enterprise 
    Title:
    Days between Step/Status
    Summary:
    OBI Days between Step/Status
    Content:

    I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status. I've tried using the TIMESTAMPDIFF but it doesn't seem to work with CASE WHEN to specify the step and status. Any ideas of what I am doing wrong? Here is an example of the formula

    TIMESTAMPDIFF (SQL_TSI_DAY, (CASE WHEN("Submission CSW Status - Historical"."Historical Step Name" = 'Recruiter Review') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'To Be Reviewed') THEN Max("Submission CSW Status - Historical"."Submission Historical Status End Date") END),CASE WHEN("Submission CSW Status - Historical"."Historical Step Name" = 'Recruiter Review') AND ("Submission CSW Status - Historical"."Historical Status Name" = 'Reviewed') THEN Max("Submission CSW Status - Historical"."Submission Historical Status End Date") END)

  • Tonya Henderson
    Any best practices for Security / User group setup?1
    Topic posted July 13, 2016 by Tonya HendersonBronze Medal: 1,250+ Points, tagged Taleo Enterprise 
    Title:
    Any best practices for Security / User group setup?
    Summary:
    best practice recommendations on security/user groups
    Content:

    We are looking at different options for security using User Groups to limit the requisitions that recruiters have access to.  Our concern is that we would still need several dispatchers to be able to assign the requisitions.  Do you have any best practice recommendations on security/user groups?

     

    We currently load draft requisitions from another system that is used by HR.  Requisitions aren't typically created in Taleo.

  • Kiran Shenvi
    Issue in OBI Catalog with folders getting moved...4
    Topic posted July 11, 2016 by Kiran ShenviGold Trophy: 10,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, Taleo Enterprise, Upgrades 
    Title:
    Issue in OBI Catalog with folders getting moved automatically
    Content:

    Hi,

    We have seen a strange behaviour where sometimes any random folder in the catalog gets moved under another folder. This happens randomly without any intention. Oracle Support says this cannot happen unless someone accidentally triggers activity but we have seen this does happen.

    Has someone else in the community also seen such strange behaviour?

    Regards,

    Kiran Shenvi