OTBI
Discussion List
-
OTBI Absence report shows different end dates on different browserSummary: Content (required): We have an absence reports which shows the employees absence. Absence type, start date and end date. However depending on which browser I us…Nicolas Vahman 64 views 9 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM -
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 22 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 23 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for reverse terminationsSummary Report for reverse terminationsContent We are currently looking to build a report that has those who may have been processed as termination but then had the term…Preston Schultz 125 views 7 comments 0 points Most recent by Abderrahim Reporting and Analytics for HCM
-
OTBI formula needed for multiple IF THENSummary: I have a simple report that uses the subject area Workforce Management - Worker Assignment Real Time. The report contains Person Name, Job Code, Job Name, Depar…
-
Embed Report in UI AppSummary: Content (required): I am trying to add a report in the UI in the onboarding App- Is this possible to do? see image I tried using page composer but it doesn't gi…
-
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…Vijay Rajendran 22 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
I am trying to learn how to determine what SQL is being issued in a Subject AreaSummary: I am trying to learn how to determine what SQL is being issued in a Subject Area. Any guidance is much appreciated. Thank you! Content (required): Specific anal…
-
Split OTBI analysis to multiple worksheet depending on certain columnSummary: Is there a way we can split an existing OTBI Analysis into multiple worksheet for each location Content (required): Version (include the version you are using, …
-
Please help on Oracle Learning activity report not pulling activity completion date.Summary: Trying to create a OTBI report for Oracle Learning activity report using Workforce Learning - Learning Management Real Time subject area . But I am not able to …Srinivas Sakinala 51 views 7 comments 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
Organization Hierarchy fields causing missing employeesSummary: We have a report that keeps dropping employees whenever we add the Organization Hierarchy fields level 2 and level 3. We have made sure the values are populated…Shanna Oppenheim 26 views 9 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How select only th last event in Recruiting - Recruiting Event Real Time Subject AreaSummary: Content (required): Hello Guys, We would create a report that extract the number of job application for each reason, but we only want take in consideration the …Giuseppe Iacono 57 views 2 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM -
Turnover report with custom column filterSummary: Hi Experts, our requirement is to create a turnover report with Active employees on the 1st of every month and the last date of every month, no of hires and Ter…Naveen setti 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…Karen Doig 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Does anyone have a report for Checklist Real Time and Transaction Administration Real Time?Summary: I am looking for a report/trying to build one for Checklist Real Time and Transaction Administration Real Time to try to report on when a Checklist has been rea…prjohnson 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for all the users along with all the rolesSummary: I am wondering if we have any report available that shows all active users with the roles assigned to them ? I am able to build OTBI report that shows Employees… -
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con…Denise Izzi 54 views 19 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Session/repository variables available in OTBISummary: Hi there, Is it possible to find out what session/repository variables are available in OTBI? Thanks for your help in advance. VijayVijay Gorania 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…
-
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi…TerryM01 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Seeking confirmation of what is stored in 'question response answer text'.Summary: We currently use OBIEE and will migrate to OTBI later this year. I do not have access to OTBI to try this for myself :) . As part of the migration I am trying t… -
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 23 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
Tuning Performance Task with Performance Ratings Subject Areas for Performance!Summary I've joined the subject areas together and it's VERY slowContent I've created an analysis where I'm trying to derive the current in progress performance task fro… -
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 322 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to add logical sql analysis to dashboardContent Hi, I have created logical sql OTBI analysis , now I want to add this into Dashboard page which is already having dashboard prompt(all are column prompts) and ot…User_7836 208 views 28 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Business Title Not Pulling CorrectlyContent We are currently migrating to use the delivered business title field, but I'm having some difficulty pulling it into an OTBI report. If I don't add any employee …User_2025-01-31-00-25-12-234 28 views 3 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row…Virginia M. Calvi 160 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…Rob F 22 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …Nicolas Vahman 14 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM