Custom Formulas
Discussion List
-
Return only latest Application Reject/Decline Motive in OBISummary Trying to pull the final reject/decline motive per application in an OBI reportContent We had Application Tracking Reject/Decline motive on a report in Business … -
Formula Help to Pull All Hires For Previous Month And Agent to Send 1st of Following MonthContent I have a weekly hired report that one user only needs monthly. I can create a monthly version to save but cannot figure out how to pull the data for the previous… -
Listing multiple hires in a single cellContent I'm using the below formula to list all of the hires in a single cell, however when I try to clean up the output using either TRIM or REPLACE I receive a SQLExec… -
Monthly Snapshot of Historical Open ReqsSummary Need Help to determine how to create a Monthly Snapshot in one ReportContent I am reporting on Trends Analysis, and i need to capture what our Reqs that were sou… -
SR 3-15603070111 : cannot access OBISummary SR 3-15603070111 : cannot access OBIContent Anyone else having issues accessing OBI? We cannot get past the login screen. I have entered a ticket with support SR… -
Reporting on Most Recent Req. CommentSummary Most Recent Req. CommentContent Hi, Has anyone successfully reported on the most recent req. comment? Our recruiters use Req. Comments as a means to keep the bus… -
Incident Number: #17-1299Summary Cannot access data in OBIContent Hello, Last night there was a notification (Incident Number: #17-1299) for OBI. The issue was "resolved" but now all of the land…
-
Pulling comments for reject/decline motiveSummary I wrote a report to pull rejected candidates with the motives, OBI pulling multiple resultsContent I wrote a report to pull all rejected candidates and the rejec…
-
How to Calculate Query 1 MINUS Query 2Content Hi All! I suspect this will be real easy for some folks! Would anyone be willing to post instruction or point me in a direction to where I might find out how I w… -
Ignore rejected candidatesSummary want to ignore rejected candidates in most advanced candidate formulaContent how can I edit this formula to ignored candidates that have been rejected. MAX(CASE …
-
Most Recent Posting DateSummary Creating a report for time to offer accepted based on posting date, want to pull only most recent posting dateContent I am trying to pull only the most recent po…Sarah Niemeyer-57906 58 views 4 comments 0 points Most recent by Sarah Niemeyer-57906 Taleo Enterprise
-
Concatenate using EVALUATE_AGGR('SYS.STRAGG(DISTINCT)Summary Need to Concatenate Multiple Rows Job Titles into 1 RowContent I need to concatenate 5 multiple rows into 1 row and 1 column separated by a # Final Output Candid…
-
Remove Textformat from fieldSummary How can I remove text format from a column in TaleoContent Hello, I'm looking to remove the following TEXTFORMAT from a field in Taleo, but cannot find the right…Cyndi Quebbemann 23 views 11 comments 1 point Most recent by Kristine Kukich-Oracle University-Oracle Taleo Enterprise
-
Custom Time to Hire using CSW StepSummary Time to Hire report using Custom Steps in CSWContent Hi, I really need some help on a custom time Hire report. Due to a number of factors at the end of the recru… -
Unable to Report on Historical Start Date ValuesSummary Ability to report on historical value for start dates in OBI when changes are madeContent Currently in OBI, users are unable to report on historical start date v… -
Format UDF Attribute from Plain Text to Date?Summary I have a UDF that is in plain text format but I need it be able to filter on a time period.Content My UDF is Relocation Date. The screenshot shows the current Da… -
Dashboard Prompts for Derived FieldsSummary Attempting to use a derived field as a dashboard promptContent Hi All, I created a derived "Region" field based on our company field. I would like to be able to … -
OBI TEE - Exclude Reqs with specific questionSummary Filter still shows reqs with excluded questionContent Need some help finishing this statement it should be simple, I'm just not getting there. I am not figuring … -
Multiple Rows into Separate ColumnsSummary We are trying to extract job submission work experiences into Separate ColumnsContent Example Data-Work Experience Recent Position Start Date End Date Job Title …
-
OBI is stuck on the "Signing In" screen after selecting Oracle Business Intelligence from the WelcomSummary cannot access OBI (SR: 3-14964633401)Content Hello, I tried logging into OBI this morning and was stuck on the "Signing In" screen. I have entered SR: 3-14964633…
-
Formula for # of candidates in Inteview stepSummary We currently have a formula to count the number of candidates in the interview step (not including those rejected) but we have added a new status and need to upd…
-
Most advanced candidate reportSummary We have designed a report to provide the details of the most advanced candidate. The report pulls the candidate's step and status and also the candidate's name, …Sarah Niemeyer-30169 73 views 9 comments 2 points Most recent by Sarah Niemeyer-30169 Taleo Enterprise
-
Help with Percentage Formula in OBIEE ReportingSummary Need tile to always display a valueContent Hello, I need to ensure there is always a value display in the tile although the value is either below 0.00% or no val… -
Required Prescreening Questions and Answers ReportSummary Report on question responses that met and did not meet requirmentContent Hopefully I am just missing something simple, but can someone help me with the following… -
Reporting on Interview EvaluationsSummary I would like to have the questions on an interview evaluation questionnaire appear as columns rather than multiple rows per question.Content Currently we have th… -
Folder Permissions settingSummary OBI folder - permission settingContent Hi there, I have changed the permission setting to a folder and selected No access to Taleo BI Admin role by mistake. Now … -
OBIEE Reports Analysis with Multiple ValuesSummary How to combine and/or remove multiple valuesContent Hello, I am building an analysis and I have multiple values for a candidate. I would like to combine them to …
-
Fast Formula HelpSummary Formula Help- Time Stamp FormulaContent Hi All, This formula works but provides all "0" results. I think I am probably missing or need a different combination of… -
Returning only one row when the person ID is duplicatedSummary If a Person ID is on 2 rows, can one of those rows be eliminated from the results based a different field?Content Hello, If a candidate (Person ID) is listed on … -
Calculate average number of days 6th external candidate moved to specific step/statusSummary Calculate average number of days 6th external candidate moved to specific step/statusContent We are in need of a formula to calculate the average number of days …