SQL
Discussion List
-
In an OBI reprt, how do I show a column that is +90 days from Actual Start Date?Summary: I have a column populated with Actual Start Date, and I need to show that date + 90 calendar days in a separate column Content (required): Actual Start Date Ver…Dawn Lomden 1 view 6 comments 0 points Most recent by Dawn Lomden Reporting and Analytics Taleo Enterprise -
Requisition Approver decision commentsContent Has anyone tried to report on the comments each approver adds when deciding on the requisition approval?Andreea Michitele 22 views 4 comments 0 points Most recent by Nonna Neft Reporting and Analytics Taleo Enterprise -
Format Fixed DateContent I want to have a fixed date in my report but I am not sure how to format it in a way that it will respond as a date for sorting and other calculations. For insta…Christian Ray 44 views 5 comments 2 points Most recent by sasamimi Reporting and Analytics Taleo Enterprise
-
CASE when statements using nullContent Ok, at least in my head this is hard to explain. I want to look at two columns. And then in a third column return a label. So, the two columns are Relo amount an…Mike Quinn 12 views 2 comments 1 point Most recent by Mike Quinn Reporting and Analytics Taleo Enterprise -
Receiving error message when filtering by promptContent Hello All, I have a SQL formula that has condensed our Organization Level 2 data to make it more intelligible for the end user. Here is the formula: CASE IFNULL(…Nick Dorfner 6 views 3 comments 0 points Most recent by Timothy Orrange Reporting and Analytics Taleo Enterprise -
Report Education History instances across columns instead of unique rowsSummary We want to report each Edu History instance for a candidate in subsequent columns so there is only one row per candidate, instead of creating a new row for each …Jordan DeLellis-15803 9 views 2 comments 0 points Most recent by Timothy Orrange Reporting and Analytics Taleo Enterprise -
Custom Formula for Pending HiresSummary Issues calculating pending hiresContent Hello, Our Recruiters have requested a number of "Pending Hires" added to reporting. This would be calculated based on th…Robert Scott-71818 14 views 2 comments 0 points Most recent by Robert Scott-71818 Reporting and Analytics Taleo Enterprise
-
Help with Duplicate Rows in Candidate Regulations FieldSummary Looking for a SQL Code to remove duplicate rowsContent Hello, I am using the Candidate Regulations "Race" field to report out hires information. I am finding tha…Kellyzuckerman 49 views 4 comments 0 points Most recent by AlyssiaKing Reporting and Analytics Taleo Enterprise -
Oracle Error code: 979, message: ORA-00979: not a GROUP BY expression at OCI call OCIStmtExecute.Summary Oracle Error code: 979, message: ORA-00979: not a GROUP BY expression at OCI call OCIStmtExecute.Content Hello I would like to seek your help regarding the SQL E…User_O9O5R 12 views 2 comments 1 point Most recent by User_O9O5R Reporting and Analytics Taleo Enterprise
-
How to convert a field (formula) from number to text or vice verseSummary Would like to combine two columns using CASE statement, one is with number format, the other is with text formatContent I have two columns in one report. Both of… -
Multiple Rows With Offer Actual Start Date FieldContent I have a referral report that is pulling all required data and uses Offer Actual Start Date as the prompt. Issue I'm having is if there are multiple offer attemp…Michelle Graham-29105 61 views 5 comments 1 point Most recent by Dawn Phipps Reporting and Analytics Taleo Enterprise -
Possible to lookup between Recruiting and Administration?Summary Possible to lookup between Recruiting and Administration?Content Hi Experts, I need to get user type from Administration, for users who have performed some actio…Sachin Sirohi 31 views 2 comments 0 points Most recent by Sachin Sirohi Reporting and Analytics Taleo Enterprise -
Gather %'s in OBI for Diversity NumbersSummary Looking for help on SQL which can calculate %'s of Diversity dataContent Good day all and Happy Friday. I have a diversity report nearly completed. I have variou…[Deleted User] 67 views 7 comments 1 point Most recent by Sara Solomon-25983 Reporting and Analytics Taleo Enterprise
-
Replacing a text from a result of Case WhenContent I am converting a formula from BO to OBI but unfortunately I am encountering an error. Below is the BO formula: Replace(Replace(Replace(If(Match([Event];"Status …Aldrin Dale Garces 44 views 2 comments 0 points Most recent by Aldrin Dale Garces Reporting and Analytics Taleo Enterprise -
Report diversity and disability at submission level vs (general) profile levelSummary 15A release notes outlines new recruiting reporting fields 'Candidate Disability Form Tracking'Content Has anyone been able to report out disability at the submi…Ger Hang 70 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics Taleo Enterprise
-
Convert Dates to Fiscal Month and Fiscal YearSummary Convert Dates to Fiscal Month and Fiscal YearContent Does anyone have a formula for Fiscal Month and Year? I need to take the Latest Filled Date and convert that…Dawn Phipps 36 views 6 comments 1 point Most recent by Michael Scaduto Reporting and Analytics Taleo Enterprise -
Calculate days posted for a specific career site and not get duplicate rowsSummary Recommendation on SQL variableContent Hello, I am calculation posting days for requisitions for the internal and external career site. My variables are generatin…Alice Kim 25 views 6 comments 1 point Most recent by Alice Kim Reporting and Analytics Taleo Enterprise -
Schedule an entire dashboardSummary Schedule an entire dashboardContent Hi there, I am trying to schedule an entire dashboard containing 3 pages (1 graph & 2 tables) but I get an error message that…Ashok Perumal 111 views 10 comments 1 point Most recent by Jairo Reporting and Analytics Taleo Enterprise -
Getting same answer to the question for all employees check-ins template in BI ReportContent I am making a report to get the answers to questions of check-ins templates.I am getting same answer for all employees who are in same check-ins meeting template…User_MC37Q 24 views 1 comment 0 points Most recent by Santosh Tekumalla-14206 Reporting and Analytics Taleo Enterprise -
Custom SQL ExamplesSummary Documentation for Custom SQL ExamplesContent Is there any documentation that shows some custom SQL examples in OBI? Thanks!Lajaun Case 54 views 3 comments 0 points Most recent by Thousif Reporting and Analytics Taleo Enterprise -
Using a filter column for posting date to prevent duplicates MAX("Requisition Posting"."Posting DateSummary Using a filter column for posting date to prevent duplicates MAX("Requisition Posting"."Posting Date") and reqs only posted once are showing blankContent Right n…Kelly Basnett 40 views 7 comments 1 point Most recent by Ellen Manthei Reporting and Analytics Taleo Enterprise -
Multiple Regulation Form CodesSummary Candidates have multiple Regulation Form Codes, resulting in duplicate rowsContent I am trying to report on the # of hires, along with details about those hires.…Prudence K 32 views 5 comments 0 points Most recent by Sang Sanford Reporting and Analytics Taleo Enterprise -
Count of submissions from the past 24 hoursContent I am trying to measure the number of candidates that apply within the past 24 hours. I have tried both variables but I am not getting the complete list. I am not…Alice Kim, SPHR-SCP 72 views 6 comments 1 point Most recent by Alice Kim, SPHR-SCP Reporting and Analytics Taleo Enterprise -
Passport ResultsSummary Previsor AssessmentContent Hello, In the past, I have had to build assessment results in the Legacy Recruiting Universe. Does anyone know if they are available i…Alice Kim, SPHR-SCP 20 views 2 comments 1 point Most recent by AnnaMN Reporting and Analytics Taleo Enterprise
-
Reporting on duplicate candidate profiles for hired candidatesSummary Reporting on duplicate candidate profiles for hired candidatesContent I'm trying to build a report that lists all the candidates that have been hired and also in…Sarah Mah 60 views 11 comments 1 point Most recent by Sarah Mah Reporting and Analytics Taleo Enterprise
-
What role do you need in Taleo to have the privilege to create and edit a Business Intelligence repoSummary What role do you need in Taleo to have the privilege to create and edit a Business Intelligence report ?Content What role do you need in Taleo to have the privil…User_6T5YF 28 views 4 comments 0 points Most recent by Lakshmi P Akkena Reporting and Analytics Taleo Enterprise
-
CSW step/status move date formula helpSummary Trying to create a CSW date move formula for each candidate ID by req. IDContent Hello, I'm trying to create a date formula for a historical step/status move by …Nicole Mays 33 views 2 comments 0 points Most recent by Nicole Mays Reporting and Analytics Taleo Enterprise
-
Time to Fill - Calculate Last Fully Approved Date to Last Position Accepted DateSummary OBI - Time to Fill - Calculate Last Fully Approved Date to Last Position Accepted DateContent We consider a requisition filled when the last offer has been accep…SteveG502 58 views 3 comments 0 points Most recent by Dawn Phipps Reporting and Analytics Taleo Enterprise
-
Pipleline Time In Process - Detail & Metrics Performance IssueSummary Pipleline Time In Process - Detail & Metrics Performance IssueContent Hi All, We have a dashboard -Pipeline Time In Process which consists of both Detail and Met…Ramesh Nakka 27 views 0 comments 0 points Started by Ramesh Nakka Reporting and Analytics Taleo Enterprise -
Conditional Formatting - Pivot Table ViewContent I'm trying to apply colored conditional formatting to a days aged value in the pivot table view in OBIEE. The measures piece of the pivot table has counts of can…Mark Lusch 38 views 4 comments 0 points Most recent by Mark Lusch Reporting and Analytics Taleo Enterprise