OTBI
Discussion List
-
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 115 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher?Raja Mohan Ivaturi 62 views 5 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
OTBI reports for Individual CompensationSummary Are we planning to launch any OTBI reports for Individual Compensation? If yes, do we have an ETA?Content We have quite a subject area for Workforce Compensation…Aparna Damle 116 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 89 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Assigment History - Old Value and New ValueSummary How can we get old value and new value for Assignment History?Content Hi All, Is there any way to get old value and new value for worker's assignment changes? We…User_2025-02-04-18-26-11-309 220 views 3 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Remove formatting characters from text in Data Model reportSummary Reporting on a free-text field in a Data Model results in formatting charactersContent We have a report set up to capture employees "career statement" from Caree…User_2025-02-03-23-33-26-899 27 views 5 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM
-
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail… -
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around…Mansur Khalil 62 views 2 comments 0 points Most recent by User_2025-02-04-06-31-44-785 Reporting and Analytics for HCM -
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…Bhuangtran 34 views 3 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Position hierarchy based on logged in person position in OTBISummary Position hierarchy based on logged in person position in OTBIContent Hi All, We are trying to get position hierarchy based on logged in person position. Suppose …Harish Kumar Kovi 74 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Page Composer Changes and OTBI Subject Area ImpactContent Will a change done by Page Composer, like Field Label change, get reflected on OTBI Subject Areas? For example if I change Person number to Employee ID on a page…Vibha Pandey - Oracle 42 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exclude logged in user from indirect reportsSummary Exclude logged in user from indirect reportsContent Hi, I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect empl…User_2025-01-30-03-54-32-528 48 views 9 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Unable to report on Element Entry HistorySummary 1=2 in SQL query?Content Hello Everyone, I'm trying to use Payroll - Element Entries History Real Time and have created a simple analysis (XML attached) to see e… -
Performance Tile IsseContent I'm trying to make a performance tile with number of Assignment events using the attached XML. I've done the same with Salary events, but for some reason its not…User_2025-01-31-00-25-12-234 51 views 9 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 245 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
OTBI Reports - Access to ResultsSummary OTBI Reports - Access to ResultsContent Hi we have created a HR Admin where they should be able to see all employee results. But this user only has access to his…Mansur Khalil 58 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM
-
Goal Weight for Mass Assigned Goal - OTBI ReportingContent We've developed a performance goal tracking report with basic information regarding an associate's goals. When pulling in the weight of the performance goal, we …User_2025-01-23-23-27-03-729 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Employee report - how to stop delegated employees appearing on it ?Summary OTBI Employee report - how to stop delegated employees appearing on it ?Content I have a OTBI manager report that managers can use to see their direct reports ho…Ruzwan Akram 48 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to restrict edit rights to analysis in specific folderContent We provided employees with the 'Human Resource Analyst' in order for them to be able to create reports. This is what we want, however with this new role they are…Marianne Kromwijk 41 views 2 comments 0 points Most recent by Timothy Orrange Reporting and Analytics for HCM
-
OTBI Report showing highest degree levelSummary Has anyone figured out how to create a report on degree information where the employee is listed under only their highest degree?Content I have a requirement for…Julia SRI International 54 views 5 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
How to adjust default selection in Line manager dashboardSummary Change default selection in Line manager dashboardContent In the Line Manager Dashboard by default one BU is marked. I want to change this to 'All'. I have copie…Wouter.Schaap 72 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 50 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
Dashboard column prompt issueContent Hi , Storing User Person Type in presentation variable and passing to logical sql , the issue is numeric values is getting passed instead of selected value, what…
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 55 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI DrillDown reporting questionSummary is there a way where we can display child drilldown report output in the parent otbi report right sideContent Hi Team, I am having one summary OTBI report & one …Pavan Gadepalli 61 views 8 comments 0 points Most recent by Pavan Gadepalli Reporting and Analytics for HCM
-
How do you report in OBI on workers who have not created any goals?Summary Cannot work out how to bring back colleagues who have not even created a goalContent Hello everyone, One of our business requirements is to be able to report on …User_2025-02-04-13-09-16-898 64 views 2 comments 0 points Most recent by User_2025-02-04-13-09-16-898 Reporting and Analytics for HCM
-
Performance Head countContent Hi How to use head count in "Workforce Performance - Performance Rating Real Time" Subject area as I count not see head count field ? ThanksUser_7836 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Turnover Calculation in OTBISummary What is the formula for the out of the box turnover calculation in OTBI?Content What is the formula for the out of the box turnover calculation in OTBI? Thanks, …User_2025-02-05-04-33-50-822 120 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…User_2025-02-04-07-00-18-658 111 views 12 comments 0 points Most recent by User_2025-02-04-18-22-33-673 Reporting and Analytics for HCM