SQL
Discussion List
-
Case (Switch) or Case (If)Summary Cannot seem to get it correctContent Hi all, I am trying to create a derived field that inserts a new value based on an existing value. For example, we have comp… -
Getting Referrer Details on the ReportSummary Getting Referrer Details on the ReportContent I am creating a referral report and would like to include Referrer (which is also an internal candidate in Taleo) d…Abiel Buensuceso Villarosa 41 views 4 comments 1 point Most recent by Abiel Buensuceso Villarosa Taleo Enterprise -
Percentage CalculationSummary Trying to write a formula to get me a percentage calculationContent The percentages I am trying to accomplish are two columns below: Historical Step 2 #Submissio…Klayna Guzman-35166 68 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
Need a report to calculate the sourcing TAT (Turn Around Time)Summary Need a report to calculate the sourcing TAT (Turn Around Time)Content Dear Experts, Need your help with a report to calculate the sourcing TAT, here is a the dat… -
Static Table for Joined Analysis?Content Is there anyway to create a static table that can be joined to an analysis? I doubt this is even possible, but what I am wanting to do is compare my pending/open…
-
Get rid of decimal places in Pivot Table with Calculated ItemContent Hello, I've added a calculated item to a pivot table using the following formula: ROUND('6 - Offers Accepted'/'5 - Offer Extended'*100) This is calculating as it… -
Average is correct, but Grand Totals not correct, weighted average?Content I have the following table that provides insights into last weeks performance. The TTF / TTS are producing straight averages in the grand total and it's not weig…
-
Requisition Primary Location Zip CodeSummary Looking to only show Primary location zip codeContent Hello, I am looking to show the primary location zip code in an OBI report. I noticed under Requisition Pri… -
Hire Start Date between 1 month ago and next MondaySummary Trying to add a filter for - Hire Start Date between 1 month ago and next MondayContent Trying to add a filter for "Submission Dates"."Hire Start Date" between 1… -
Application Historical Tracking Date and corresponding Application Historical CSW StepSummary Application Historical Tracking Date and corresponding Application Historical CSW StepContent This is an easy one but my brain is fried with the upcoming holiday… -
Need to display which candidate filled the last open position of filled requisitionsSummary We are not able to display which candidate has filled the last open position of filled requisitionsContent Hi, We have created below custom formula to display th…
-
Create a variable to count offer accepts where start date is > current dateContent Hello, I am creating a table that counts by location the various stages of the candidate life cycle. One of those counts is on offer accepts where the start date… -
Compliance reportSummary Trying to filter report to show personnel areaContent Creating a compliance report from BO to OBI that is using a subquery. Need to use the Req Identifier to wri…
-
OBI Date Prompt on Custom SQLSummary How do I create a prompt on a custom sqlContent Hi, I have a report which I could only create by custom SQL. When I created the report, I hardcoded the dates and… -
Current Date/Time Stamp in OBI AgentSummary Looking to put a date/time stamp in the subject line of my OBI agentContent Hello, I would like the subject line of my OBI agent to contain the date/time of the …
-
How to get the nationality of a candidate or the language spoken by the candidate?Summary How to get the nationality of a candidate or the language spoken by the candidate?Content Hi All, One of my team members wanted to access all Dutch speaking cand…
-
How do I reference another report without filtering?Content Not sure if there is a way to do this. Ideally I am looking for a capability similar to a vlookup in Exce where I can combine the results of two reportsl. If I c…
-
Pull Analysis with Current Status as of a certain time/dateContent Hello, I have a graph set up in OBI where I need to re-pull it as of last Friday 10/28 as of noon. I already have a filter on it for Req Creation date less than …
-
Reporting on requisition posting statusSummary provide detail on whether or not a requisition is posted to a specific career siteContent In Business Objects I was able to include information on whether or not…Alice Kim, SPHR-SCP 44 views 7 comments 2 points Most recent by Alice Kim, SPHR-SCP Taleo Enterprise
-
"Submission Tracking History"."Transaction Details" and "Submission Tracking History"."Transaction ESummary Help with finding candidates who did not get the standard rejection correspondenceContent I have been tasked with reporting on the number of applicants who were …
-
Previous Employer Value from OBI ReportingSummary Need to know which field to include in a report to get the previous employer value of an applicantContent Hi, I am currently working on creating a report in OBI …
-
Latest - Historical Step/Status CommentsSummary Latest - Historical Step/Status CommentsContent Hi there, I have created a report (attached) and I added Historical Step/Status Comments. However, I got the repo… -
Calculating Percent Difference between two columnsSummary Calculating Percent Difference between two columnsContent Hello - Does anyone know the best way to calculate the percent difference between two columns? We are t…Valerie Reyna Villarreal 54 views 1 comment 0 points Most recent by Santosh Tekumalla-14206 Taleo Enterprise -
Latest - offer accepted dateSummary Required formula for populating latest - offer accepted dateContent Hi there, I have created a report that contains all hired candidates details. I have populate…
-
Formatting as date within stringContent I am trying to rip the last 10 characters off of a comment which contains a date, and then determine the difference between that date and the start date, but I a…
-
How do I combine rows without a pivot table?Content Is there any easy way to collapse these rows within a table through SQL? I want one row per req, with each variable in it's own column. Each of these variables a…
-
Reporting on Profile Sources/ Source TypesSummary OBI Assistance- Profile Source FieldsContent Hello, I am trying to splice out my "Profile Source" field in OBI into two separate columns. Current report: Candida…
-
Return only the most recent General Profile- OBISummary Looking for a formula to return the most recently created profileContent Hello, I am having issues reporting on General Profiles. I am using all candidate fields…
-
Customer and Project detailsSummary Customer and Project detailsContent Hi there, I am creating another report including hired details. I am trying to find customer id, customer name, project id an…
-
Req. Saved as Open Date and ageing weekSummary Req. Saved as Open Date and ageing week calculationContent Hi there, I am create an average time to fill report and I have added all fields except two fields tha…