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… -
Requisition Approver decision commentsContent Has anyone tried to report on the comments each approver adds when deciding on the requisition approval? -
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…
-
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… -
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(… -
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 … -
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…
-
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… -
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…
-
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… -
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… -
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…
-
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 … -
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…
-
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… -
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… -
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… -
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… -
Custom SQL ExamplesSummary Documentation for Custom SQL ExamplesContent Is there any documentation that shows some custom SQL examples in OBI? Thanks! -
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… -
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.… -
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… -
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…
-
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…
-
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…
-
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 …
-
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…
-
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… -
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…