OTBI
Discussion List
-
Count of Employees with and w/o Goals by Assingment Manager (Unsecured)Summary Is it possible to create an Goal analytic by Assingment Manager (Unsecured)Content Hello, Based on the post from Sivakumaran Muthusamy in March, I have created a…User_2025-01-23-22-38-50-675 58 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Duplicate Rows for a report trying to capture each employees self and manager evalsSummary Performance Review ReportContent I'm trying to create one report which will capture an employee's self eval and performance review status'. If it worked perfectl…User_2025-01-28-08-47-04-905 68 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
OTBI Head count report sorting by Division(Error: No Result Found)Summary OTBI Head count report sorting by Division(Error: No Result Found)Content Hi Team, I am looking for a report in OTBI with Division , Employee count and System pe…User_2025-01-30-05-05-05-573 82 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Salary History with current salary detailsContent Hi I have a report requirement , when selecting the year form dropdown the salary details has to be display for that year for all employees. So, for this I have …User_7836 514 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Completed, Scheduled and PTO BalanceSummary How to show completed PTO when someone has not entered any.Content We have created a dashboard item for managers. This tells managers what their associates PTO i… -
Salary History report errors outContent I need to create a report that pulls future dated salaries loaded from Workforce Comp. I'm trying to create a simple analysis using the "Compensation - Salary Hi…Gala Meyerovich 74 views 11 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
OTBI Department Hierarchy Report giving No ResultsSummary OTBI Department Hierarchy Report giving No ResultsContent Hi Team, I am trying to run a OTBI report for Department/Organisation Hirarchy in my Client instance, h…User_2025-01-30-05-05-05-573 113 views 4 comments 0 points Most recent by User_2025-01-30-05-05-05-573 Reporting and Analytics for HCM
-
BI publisher report for persons who ticked yes for an interview with their HR contact .Summary Tables where I can find question and responses for interview between salaries and their managerContent Hello, I want to create a report to display alls persons w… -
Talent PoolsSummary Is Talent Pool information still only available through BIP?Content I'm trying to pull talent pool participant information through OTBI, with no success. I do kn…User_2025-01-28-08-47-04-905 61 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
How to drill down pivot table head countContent Hi , I have below pivot table with columns as Age and rows Division and Measures as Head count, now I want to prepare drill down report on click of the Head coun…
-
OTBI ACTIVE HEADCOUNT By CONTRACT TYPESummary Cross active headcount and contract typeContent Hello, I want to create a simple report that display active headcount by contract type and by Business Unit. BU e…User_NVBN4 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Management Subject AreasContent Is there any performance management subject areas which are allowing access to the Line Manager job role? I have referred below document. But all listed performa…User_2025-01-28-21-18-43-496 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to troubleshoot Poor Performance of OTBI Reports?Summary Poor PerformanceContent Hello, I am hoping someone will help me here - we are experiencing very poor performance with most of the OTBI reports. The minimum run t…SantoshKumarBhairi 95 views 5 comments 0 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM -
OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? input - Report Name Output - list of users who ran thi…User_2025-01-25-04-02-13-126 156 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…Achala Munasinghe 122 views 4 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for HCM -
Performance Reports - Leaders not seeing resultsSummary Report is blank when opened by a LeaderContent I have created 3 performance related reports (Document Status, Rating Detail and Rating Distribution). When I open…User_2025-01-28-20-43-56-568 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Learning Evaluations Report in OTBISummary Cannot Report Learning Evaluations DataContent I am trying to create an OTBI report that contains data from the Learning Evaluations folder in Workforce Learning…User_2025-01-28-17-24-53-863 193 views 3 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Performance Document Status with drill down capabilitySummary How to create drill down capabilityContent Hi. We are in the middle of our performance review process. I created a report (bar graph chart) for Leaders to use to…User_2025-01-28-20-43-56-568 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
OTBI limitationsSummary What are the main OTBI limitations compared to BI Publisher?Content Hi Folks, Is there any place where I can find the list of restrictions on using OTBI? For exa…Alvaro Couto 178 views 12 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 98 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 95 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da…Prudence K 88 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM
-
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an…Vivek Pathak-71652 23 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 76 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f…Prudence K 147 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Ability to report on historic versions of the Org Tree using OTBISummary Ability to report on historic versions of the Org Tree using OTBIContent Hello Team, Does OTBI has the ability to report on historic version of Org tree? I tried…Suveer Tn 83 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 84 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM
-
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM