Analyses
Discussion List
-
Reporting on # of open reqs in a selected past time periodSummary a snapshot of open reqs in a given time periodContent Hi! I am trying to build a report to compare numbers of reqs that had been open/active (sourcing status) on… -
OBI and Offer ParagraphsSummary: We've been asked to add a field on one of our Incentive reports that would list the offer paragraph selected related to the incentive. It can be the code for th…
-
OBI did not pull out all the field valuesSummary: I created an analysis under the Subject Area of SMRTORG. The analysis consist of the following columns: Users, Account Status, User Group. I noticed that the re…
-
Is it possible to sort the values in the legend of a pie chart?Summary: I would like to display the labels in the legend of my pie chart in a specific order. Content (required): Hello, I would like to display the labels in the legen…
-
Requisition Approver decision commentsContent Has anyone tried to report on the comments each approver adds when deciding on the requisition approval? -
Calculating # applicants received/reviewed per hireContent HI! Does anyone have a way to calculate how many applicants were received/reviewed per hire (or group of hires by job function) in a given time period? I found a…
-
Is it possible to show # of submissions only for previous day?Summary: Looking to display number of submissions submitted on previous day for each requisition Content (required): Hi all--we've been asked to try and provide a report… -
Is there any way to do a math equation within a Pivot Table in OBI?Summary: Is there any way to do a math equation within a pivot table? The formula that I created is not working within the criteria tab. I'm trying to take Days Less 20 …
-
Is there a way to report on recipients of a scheduled agent?Summary Is there a way to report on recipients of a scheduled agent?Content Can I create a report on who is sent an OBI report via a scheduled agent? I don't want to hav… -
Formula to Display Time ZoneSummary Formula to Display Time ZoneContent Is there a way to display time zone in an OBIEE report? For example, Hired Date field - I would like to display what time zon…
-
Maximum Historical Status of a Req as of a point in timeSummary We want to know what the maximum historical status of each Req as of the beginning of each monthContent We want to know what the maximum historical status of eac… -
Email users based on report resultsContent Trying to create a daily report which is only delivered to hiring managers included in the report. The fields for the report are req id, req current status, and … -
OBI Report: Historical Status DateContent Hi, I have a report built to send data for candidates that have accepted an offer within a certain period of time. This report runs twice, daily. It runs at 7AM … -
Fiscal Week or Month reporting in OBISummary how to define dates when fiscal year does not correspond to calendar yearContent Hi! Our Fiscal Year this year started on January 1/31/2021. That was day 1 of we…
-
Average Time From One Status To The NextContent I am trying to calculate the average time in days it takes our recruiters to move candidates from one status to the next by Requisition. I am able to get the cal…
-
Report on if candidate referral was effective at time of hireContent So when someone gets referred, they are active as the referrer for 120 days, then it shows Not Effective after that date. I'd like to report on how many candidat… -
Agents - Is it possbile to adjust Prompts when scheduling an agentSummary Agents - Is it possbile to adjust Prompts when scheduling an agentContent There seems to be a limitation with the ability to adjust prompts when scheduling an ag…
-
Formatting items on a graphSummary Need help with formatting dates and data on a graphContent Please help with me with converting week number to a correstponding date as shown in the attached docu…
-
Report column to show # submissions in a specific step/statusSummary please advise on correct formula syntaxContent I need to pull the number of candidates currently in the "New" step and the "To Be Reviewed" status. I am using th…
-
Offer ReportingSummary I need to report on Offer DatesContent I would like to create a report on offer dates and am struggling with how to do that. I am trying to report on what the Of… -
Exporting Attachments details - Visible to Candidate FlagSummary Exporting Attachments details - Visible to Candidate FlagContent Hello Experts I am trying to export all the attachments to candidates general profile or submiss… -
Hire Start Date suddenly off a dayContent So on Monday's we run an automated analysis of upcoming hires via the Hire Start Date field. It's been fine up until today. It now is showing Hire Start Date one…
-
Add "average" value at the bottom of a result columnContent Hi! How does one add a value = average of numeric values in a result column? I would like it to be a field that is visible in the report vs downloading the resul…
-
-
Reporting on #s of candidates that had EVER been in specific steps/statusesContent Hi! I am new to both OBI and Taleo and am looking for some guidance on a specific internal customer ask... I am being asked to create a report that would show fo…
-
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(… -
Scheduling agent to go to a recipient used in analysis condition?Summary Cannot successfully schedule an agent to email results to field (recruiter) in analysis.Content I'm trying to schedule a simple analysis/audit to run and deliver… -
TIMESTAMPDIFF between two statusContent Hello, I would like to calculate the number of days between two date from CSW status; I tried this formula : TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Submission CSW…
-
Pipeline type reportContent Does any one have a kind of pipeline report that shows the average amount of days a candidate spends in kind of custom "windows" as I call them? For example, how…
-
OBI report how to show only most recent candidate submissionSummary In a report of all submissions for a time period, how to only show the most recent for each candidateContent I have a report of all submissions for the year, and…