OTBI
Discussion List
-
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new… -
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add New Column Based on Days Between Two Dates ResultI'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Dat…
-
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…
-
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 21 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Multiple keywords in single OTBI column filterSummary: Hello everyone, The client is building some OTBI reports and would like to include multiple keywords in one column filter by typing the text in and not selectin…PriyaPenugonda-SC 41 views 4 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
How to connect a course with specialization in OTBIHi Team, Can you please tell me How can we connect a course with specialization and how can we get the learning outcome of a person from the respective course. Thanks
-
HeadCount OTBI reportSummary: Hi all I added these subject areas in my otbi reports:- Workforce Management – Worker Assignment Real-Time Compensation – Salary Details Real Time Workforce Man…Deepak Bhatt 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fixed Assets - Asset Balances Real Time: Balancing Segment Changes on Opening Balance/Beginning BalaContent Fixed Assets - Asset Balances Real Time: Balancing Segment Changes on Opening Balance/Beginning Balance The Asset Balances Real Time subject area switches Balanc…
-
DFFs no longer available in applicable Subject AreasSummary: Production Report Errors - DFFs no longer available in applicable Subject Areas Content (required): Has anyone had issues with DFFs in Analyses? Beginning the a… -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
E-Mail Notifications in Learning (for Learners & managers)Content Hi all, we are struggling with e-mail notifications for Learners. We need to notify Learners via e-Mail, as soon as certain events occur. E.g.: The learner is as… -
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 41 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 23 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 153 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Query to extract ExternalWorkerDataId by Start/End Date and Person NumberSummary: Hello experts, I should update external worker data. However, ExternalWorkerDataId information is not available in OTBI analysis. Is there a query available to …Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Learning - What OTBI Subject Area can be used to with Analysis Criteria to identify a new ManagerContent There is a business requirement to have a Learning Initiative to enrol on a specific course anyone who has just become a supervisor/line manager for the first ti…
-
Error running OTBI AnalysisSummary: Getting error ' Incorrectly defined logical table source (for fact table Z - VO OBIA ETL) does not contain mapping for....' Content (required): I've had this sa…Susan Anderson 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Leavers not showing now on manager dashboardsSummary: Leavers show very small numbers or nothing Content (required): My dashboard reports have been working fine but now I'm getting reports from managers that they c… -
Report showing latest Talent ScoreSummary Report showing latest Talent ScoreContent I'm trying to create a report which shows the latest Talent Score for each employee, where some of these will have been…