OTBI
Discussion List
-
Job Incumbents 10th 25th 50th 75th 90th incumbent baseSummary: We are building an otbi dashboard that can be leveraged to report on incumbents jobcodes and paygrade ranges. We have the base report with jobcodes and number o…Akshay.Agarwal 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Sharing Recruit to Hire Dashboard -- download catalog fileSummary: I know I have seen a posting that shared the delivered Recruit to Hire Dashboard in a customizable download file. Can someone share the link to that posting? I …Ellen Manthei 61 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pivot table help - Measures dont sumSummary: Measures in a pivot table do not sum, instead appear as a 1 regardless of total. Content (required): Im new to OTBI and dislike pivot table (OTBI, excel, anywhe… -
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Manager Details (more than one)Summary Writing an OTBI Report which pulls all of an employee's managersContent Hello, We record two managers for each employee at our company. One is the line manager a…John Gerbracht 103 views 8 comments 0 points Most recent by Kris Cregger Reporting and Analytics for HCM
-
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 41 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 62 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 307 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 32 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 31 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 31 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM
-
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 31 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to show only the MAX response attempt for a questionniare response in OTBI analysisSummary: We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to p…Amy Wilson 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 289 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 91 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 34 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 41 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,…
-
sum of 2 columns to be shown in 3rd column in OTBISummary: Hello, We are trying to sum 2 columns data and show it in 3rd column, however, it is not working. candidate-Job Applied + Candidate-Prospect = Total Referred Ca…Shiva Prasad M 113 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI?User_2025-01-25-03-18-49-935 97 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature …Amy Wilson 41 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 334 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 42 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 44 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
GETTING ERROR WHEN USING TWO SUBJECT AREASummary: I HAVE ONE SUBJECT AREA "Procurement - Procure To Pay Real Time'' I SELE CT PO NUMBER , CREATION DATE , CLOSED DATE, AND FROM ANTHOR SUBJECT AREA ''Procurement …
-
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…Julia SRI International 453 views 9 comments 0 points Most recent by RamyaK Reporting and Analytics for HCM