OTBI
Discussion List
-
Nice look and feel outcome when NO result in OTBISummary How to display a nice page in case of NO result in OTBIContent Hi, do you know if there is some way to display a courtesy page if no result in a OTBI analysis? T…Nicola Petri 45 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…CB Trett 89 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
OTBI CapabilitiesSummary OTBI CapabilitiesContent Hi Experts, I hope some of you will agree that although OTBI has advanced features and capabilities still some consultants prefer to use…AshishERPCloud 307 views 5 comments 4 points Most recent by Kalyani Koylada Reporting and Analytics for HCM -
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 56 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 55 views 8 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 52 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM
-
COUNT of new hires and veteransSummary Calculate the count of 2 custom fieldsContent Hi Team, I am calculating the count of employees who are new hires and veterans. Below is the query used which is n…Kalyani Koylada 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…Ankush Rode 60 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Absence BalancesContent Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in … -
Conditional Formatting of Blank Cells not workingSummary I want Null / Blank Cells in RedContent Hi, I have a report (see XML attached) that has 17 columns, some of which have missing data (NULLS). All I am trying to d…User_2025-02-05-22-44-35-842 33 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Department name not available in Position Subject area - causing duplicate rowSummary Looking to report on position listing and incumbent information and getting duplicate rowContent Hi there, I have created a report based on position and have add…Mario B 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 85 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 53 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Involuntary Turnover ReportSummary Involuntary ReportContent Hi, I'm trying to build a report from scratch that will show the number of involuntary leavers and their reasons (e.g. redundancy) etc …User_2025-02-05-22-44-35-842 31 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 54 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
YTD MTD QTD Balance reports for 401KSummary YTD MTD QTD Balance reports for 401KContent Hi Team, I heard that we do not have Time to date (YTD,MTD, YTD dimensions in OTBI. I have to fetch 5 YTD values for …SM-Oracle 84 views 3 comments 0 points Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM
-
Is there any option to change field name in Data VizSummary Is there any option to change field name in Data VizContent Hi Gurus Is there any option to change the field label in Data Viz (OAC). Like in data set column nam…Saptadip 19 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI - Limit results in a bar graph only out of 10, but not on dataSummary Limit results in a bar graph only out of 10, but not on dataContent Hi all we build a report with several graphs. For the attached graph we need to list the top …Nicola Petri 60 views 5 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 116 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
filtering by custom promptSummary We setup a custom prompt but we need to understand how to link into filtersContent Hi Ladies & Gentlemen, we configured a custom prompt based on following SQL co…Nicola Petri 54 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to add a date promptSummary I would like to add an 'As At' date prompt to an existing basic employee analysis reportContent Hi, I'm relatively new to OTBI and unable to add a 'as at' date p…User_2025-02-05-22-44-35-842 137 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …Mario B 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify employees who haven't created any performance goals and those who haveSummary Looking to create a quick reference report for Division heads to see which employees have created goals and which have notContent I have been trying to use the G…Mario B 174 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Using external data in OTBIContent Hi folks! help needed! We are implementing a manager dashboard, where we need to use default expense account field. As confirmed in the following post…Nicola Petri 41 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 118 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM
-
Daily Breakdown ProcessSummary Workforce Management Absence Calendar Details Real TimeContent Hi, I've received a request to build an absence report using the 'Workforce Management Absence Cal…User_2025-02-05-22-44-35-842 37 views 8 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Create a prompt on a calculated fieldContent Hi, can you suggest a way to create a prompt based on a calculated field? Thanks a lot! NicolaNicola Petri 27 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
The Data is of zero or negative value and cannot be displayedContent Hello, Is there a way to customize/change the message which returns when a column result is zero? 'The Data is of zero or negative value and cannot be displayed'…Susan Anderson 32 views 4 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Document Submission Date and HourContent Hello experts, How can I track the Performance Document Submission Date and Hour in reporting? Are there any field in OTBI reporting that allow me to get these i…Samanta Lorando 14 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM